May 23, 2021 07:12 PM
I wrote the codes as below:
IF({Priority of task} = OR("Emergency","Important","Urgent"), SWITCH({Days until deadline},3,"3️⃣",2,"2️⃣",1,"1️⃣",0,"‼️"),"This is not an important task")
But the result is that all tasks shows “This is not an important task” even the priority is emergency. I wonder is it due to the misuse of OR() in the formula? Can OR() be used like IF(… = OR(…, …, …) , … , … ) this way? Thanks.
Solved! Go to Solution.
May 23, 2021 07:46 PM
Welcome to the Airtable community!
Correct. Try this instead:
IF(
OR(
{Priority of task} = "Emergency",
{Priority of task} = "Important",
{Priority of task} = "Urgent"
),
SWITCH( {Days until deadline},
3,"3️⃣",
2,"2️⃣",
1,"1️⃣",
0,"‼️"
),
"This is not an important task"
)
May 23, 2021 07:46 PM
Welcome to the Airtable community!
Correct. Try this instead:
IF(
OR(
{Priority of task} = "Emergency",
{Priority of task} = "Important",
{Priority of task} = "Urgent"
),
SWITCH( {Days until deadline},
3,"3️⃣",
2,"2️⃣",
1,"1️⃣",
0,"‼️"
),
"This is not an important task"
)