I am having issues referencing multiple columns using the IF statement.
I have 2x formulas:
=IF([Delayed?]@row = "Customer Delay", "Customer Delay")
=IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress")))
Both work independently from one another. I'd like for this formula to used in the 'Status column (once combined). The challenge I'm having is combining the two into one cell. When I combine them, I get the "UNPARSABLE" message:
=IF([Delayed?]@row = "Customer Delay", "Customer Delay"), IF([% Complete]@row = 1, "Complete", IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress")))
Answers
-
Try removing that first closing parenthesis after "Customer Delay".
-
Ah! I was sooo close! THANK YOU!!!!!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 142 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!