Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 02:19 AM
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!
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 04:31 AM
Try a SWITCH:
 
SWITCH(
Options,
"under 2h", 1,
"up to 8h", 2,
"a day", 3
)
Reply
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 04:31 AM
Try a SWITCH:
 
SWITCH(
Options,
"under 2h", 1,
"up to 8h", 2,
"a day", 3
)
Reply
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 19, 2024 05:36 AM
Thank you! This worked!
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)