Skip to main content

Hi all,

I want to prioritise datasets in Airtable. For that I've created checkbox fields and a drop down field.
I now want to create a formular field and add there a weighted text drop down menu by giving each text option a number.

 
For the checkbox fields it's clear: If it's checked, then value1, if not, then value2:
IF(logical, value1, value2) + IF(logical, value1, value2) + 
 
But how can I add the weighted values from the drop down menu in the formular?
For example IF option1, then 3, IF option2, then 2, IF option3, then 1, otherwise 0)
IF(logical=1, 1, 0) + IF(logical=1, 3, IF({logical=2, 2))
 
In detail, this is the formular which is not working:
IF({easy to implement?}=1, 3, IF({easy to implement?}=2, 2, IF({easy to implement?}=3, 1))), 0)
nor does
IF({easy to implement?}=under 2h, 3, IF({easy to implement?}=up to 8h, 2, IF({easy to implement?}=a day, 1))), 0)
 
Do you have ideas?
Thank you!
 

Try a SWITCH:

SWITCH(
Options,
"under 2h", 1,
"up to 8h", 2,
"a day", 3
)


Try a SWITCH:

SWITCH(
Options,
"under 2h", 1,
"up to 8h", 2,
"a day", 3
)


Thank you! This worked!


Reply