This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi.
Is it possible to set a conditional formatting with 3 results?
If the result of 80 or more, the cell shows “Go”
If the result is lower than 80, but higer than 50, the cell shows “Caution”
If the result is lower than 50, the cell shows “Run”.
Than...
Hi.
There’s a way to put a value in one column and depending on the number, it automatically choose one of pre existent values in another? That way:
I’ll have a column named “Grade” and another named “Rating”. In the column grade, I’ll put numbers fr...
Hi! How are you?
I’m new, and I’m having trouble with the average. I want to calculate the average of ao column that will ever grow (each day I’ll add new numbers). But when I create a new column to calculate it, it just repeat the numbers, instead o...
Worked. Thanks Now I have the ultimate Airtable to use in my negotiations (I’ll know exacly, how much discount can I give, and how much everything will cost to me and to my clients).
Chester_McLaughlin:
IF (
{Result} >= 80,
“Go”,
IF (
{Result} >= 50,
“Caution”,
“Run”
)
)
Thanks for the answer. But I’ve made that, and it didn’t worked. I’ve read the formula field reference, and the conditional formating reference, and it di...
