- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 03:07 PM
I need to calculate a number based on selected single select option in another field.
For instance if the users chooses “Excellent” then the number should be 10, if the users chooses “Good”, then the number shoud be 7, if the users chooses “Fair”, then the number should 5, if the users chooses “Poor”, then the number should be 3, other wise it should be blank.
It so that I can then tally the score of nine different fields for a total score.
Suggestions?? Formula? I’m fairly new to Airtable and I’ve trid numerous formulas toget this to happen an so far have failed.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 03:23 PM
Simplest formula:
SWITCH(
{Gravel Layer Rati...},
"EXCELLENT", 10,
"GOOD", 7,
"FAIR", 5,
"DEFICIENT", 3
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 03:23 PM
Simplest formula:
SWITCH(
{Gravel Layer Rati...},
"EXCELLENT", 10,
"GOOD", 7,
"FAIR", 5,
"DEFICIENT", 3
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 03:30 PM
Thank you! We’re getting closer !
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 03:39 PM
Thanks to Kamille for the formula
SWITCH(
{GRAVEL LAYER RATING},
“EXCELLENT”, 10,
“GOOD”, 7,
“FAIR”, 5,
“DEFICIENT”, 3
)
Though I’m still trying to figure out why “Excellent” and “Fair” don’t generate a number.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 03:43 PM
OMG! There was an extra space after the ord in the Single Select option… once I got rid of the extra space, the formula worked perfectly!
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2021 04:30 PM
Glad to know that you got the answer you were seeking! Because @Kamille_Parks’ comment above was the primary solution to your question, please mark her comment as the solution. Correct marking helps others who may be searching with similar questions to find those answers more quickly. Thanks!