Assistance with stringing multiple IF statements
I need to create a string of 3 IF statements and I can't seem to get it right. I have tried multiple ways of doing this and currently have the following:
=IF(ISBLANK([HowMany?]@row), 0),
IF=IF([HowMany?]@row=1), 1),
IF([HowMany?]@row), =2), 2)))
Essentially I have a field labeled HowMany? where the value will be one of blank, 1 or 2. In another field, I want to evaluate HowMany? and if it is blank, I want it to state 0 and if it is not blank, I want it to state the value from that field (either 1 or 2). Any help would be greatly appreciated. Thank you!
Best Answer
-
Please disregard, I got it to work with this:
=IF([HowMany?]@row = 1, 1, IF([HowMany?]@row = 2, 2, 0))
Answers
-
Please disregard, I got it to work with this:
=IF([HowMany?]@row = 1, 1, IF([HowMany?]@row = 2, 2, 0))
-
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!