Nested IF
Hi everyone,
Few questions all interrelated.
- I disguised my actual field names, but this returns a blank cell.... how can that be? Shouldn't it return either Done or Not Done?
- I added ,"x" after Not Done and it didn't break it. Still returned blank cell. Odd that I did not get an UNPARSABLE message.
- First attempt, I built this in Word and copied it into Smartsheet. Same exact character for character, but kept getting UNPARSABLE message. Even used CLEAN function in Excel to remove hidden chars, but still returned UNPARSEABLE. When I keyed it in character by character into Smartsheet, it did not throw the UNPARSEABLE.
=IF([1Status]@row <> "N/A",
IF([1 Status]@row = "Done",
IF([2 Status]@row <> "N/A",
IF([2 Status]@row = "Done",
IF([3 Status]@row <> "N/A",
IF([3 Status]@row = "Done",
IF([4 Status]@row = "N/A",
IF([4 Status]@row = "Done", "Done", "Not Done"))))))))
Rather bewildered,
Tim
Best Answer
-
We worked around it by developing a different formula. As for the #unparseables, I cannot recreate it now but when it happens again I'll provide screenshots of the copy/paste workflow.
Answers
-
Let me add that all of the status fields are of type Dropdown Single-select, and it has five choices, of which 2 are N/A and Done.
-
Hi @palmcitytim ,
Hope you are Good and Safe!
If you are ok means Could you please explain it with Screenshots so that it would be easy to understand.
Thanks,
Sandhiya P
-
We worked around it by developing a different formula. As for the #unparseables, I cannot recreate it now but when it happens again I'll provide screenshots of the copy/paste workflow.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!