Drag & Drop

[Mandy_BG]

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!

[TheTimeSavingCo · Accepted solution]

Try a SWITCH:
 

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

[Mandy_BG]

Thank you! This worked!