do a calculation based on drop dowm list
Hi,
I have same data comming from differents drop down lists and I am trying to do some calulation based on them, each list represent a certain % in my calulation. I have hard time to do any type of caluclation with them, please help if you have an idea.
Answers
-
Hi @Otman
Can you post a screen capture of all the values in your dropdown list, and let us know what you want each selection to represent?
ex:
Dropdown option: "Value 1" = 20%
Dropdown option: "Value 2" = 40%
Then we can write a Nested IF statement that says, if the column is "Value 1", return 0.2 (or 20%).The formula would looks something like this:
=IF([Dropdown Column]@row = "Value 1", 0.2, IF([Dropdown Column]@row = "Value 2", 0.4, IF([Dropdown Column]@row = "Value 3", 0.6, IF([Dropdown Column]@row = "Value 4", 0.8, IF([Dropdown Column]@row = "Value 5", 1)))))
Does that make sense?
Cheers,
Genevieve
-
Hi Genevieve,
Thank you for your answer, I would like to do a further caluculation based on va;lues obtained by using a formula in Smart sheet such as
=IF(Impact@row = "Negligible"; "1"; IF(Impact@row = "Minor"; "2"; IF(Impact@row = "Moderate"; "3"; IF(Impact@row = "Significant"; "4"; IF(Impact@row = "Severe"; "5")))))
Thank your for your help, I highly appreciated
-
Hi @Otman
I see you have quotes around your numbers in the formula. This means they're being returned as text, not as numbers, which is why your other calculation won't work.
Instead of:
=IF(Impact@row = "Negligible"; "1"
use:
=IF(Impact@row = "Negligible"; 1 < No Quotes
Ex:
=IF(Impact@row = "Negligible"; 1; IF(Impact@row = "Minor"; 2; IF(Impact@row = "Moderate"; 3; IF(Impact@row = "Significant"; 4; IF(Impact@row = "Severe"; 5)))))
You will need to do the same for the formula in the Risk Values column. Does that make sense?
Cheers,
Genevieve
-
Hi Genevieve,
It works, thank you very much for your help, have a nice day
Best regards
-
Hi Genevieve,
I have another questions, and I would like you to help me on it (Calculation from Smartsheet forms via different smartsheet), thank you in advance for your help and amability.
Best regards
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!