Skip to main content

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.

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"

)

Reply


Terms & Conditions