Help

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

Solved
Jump to Solution
380 0
cancel
Showing results for 
Search instead for 
Did you mean: 
thera_luis
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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