Multiplication with results of an IF Statement
Hello,
It appears you can't do calculations with the results of a nested IF statement?
=(IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))) * [Number]1
It appears I have to have the IF statement alone in one column, and then the math in another column.
=IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))
=[Formula]1 * [Number]1
Is there a way to condense this down to one formula, or are we stuck with math in an if statement being two cells?
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
Comments
-
Hello. The FAQ docs aren't clear.
The problem is I used "quotes" when you need a numerical value, drop the quotes. Smartsheet isn't smart enough to exclude it. It'd think it's a text based value.
=IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))
should be
=IF([Shift Duration]1 = "2 Hours", 3.75, IF([Shift Duration]1 = "3 Hours", 2.5, "NA"))
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
-
That is correct. Using quotes generates a text string.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives