Multiple IF statements using a dropdown
Hi all.
Using a dropdown column with values: 0, 110. 20100, can you use multiple IF statements in a formula in another column (cell) that states  IF cell = 0 then value equals 1 & IF cell = 110 then the value must equal 20 & IF cell = 20100 then the value equals 50.
Is this possible??
Any assistance would be greatly appreciated.
Best Answer

Hi @Trav25
If I understand your question correctly, then a nested if formula should work in your case. Here is an example
 Sheet with one column with drop down value named as "Drop Down" having values  0, 110, 20100
 Another column with formula named as "Formula Column"
 Use formula in "Formula Column" as "=IF([Drop Down]@row = 0, 1, IF([Drop Down]@row = "110", 20, IF([Drop Down]@row = "20100", 50)))"
Refer screenshot
Let me know if this is correct representation or if you have a different scenario.
Regards,
Saurabh Maheshwari
Smartsheet Superstar
Portfolio Lead, TCS
Answers

Hi @Trav25
If I understand your question correctly, then a nested if formula should work in your case. Here is an example
 Sheet with one column with drop down value named as "Drop Down" having values  0, 110, 20100
 Another column with formula named as "Formula Column"
 Use formula in "Formula Column" as "=IF([Drop Down]@row = 0, 1, IF([Drop Down]@row = "110", 20, IF([Drop Down]@row = "20100", 50)))"
Refer screenshot
Let me know if this is correct representation or if you have a different scenario.
Regards,
Saurabh Maheshwari
Smartsheet Superstar
Portfolio Lead, TCS

Thanks for the quick response, that's what I had used, but realised it was an error in my formula.
Thanks so much!
Trav

Glad to know that it worked.
Regards,
Saurabh Maheshwari
Smartsheet Superstar
Portfolio Lead, TCS

Hello there,
this answer has helped me greatly but I am struggling to extend this to the number of values I have in my dropdown. I've tried adding more, copying and pasting and adding a bracket but I keep getting the unparseable error.
How would you go on to extend this to include more dropdown values  what am I missing?

Hi @CarlaT
Can you post the formula you've been trying, a list of your dropdown values, and an explanation of what you want to happen in each instance? We'd be happy to help you with this!
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!