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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives