Can I use 'OR()' after '='?

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"
)
3 Likes

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.