Status change formula using IF function
I have a status column that I would like to set up a formula in to do two things
a) Change status to "Needs Update" when a date in a date column is reached
b) Change status to "Prequalified" when three checkbox columns are all chacked
Here is the formula I have so far:
=IF([Expiration Date]@row = TODAY(), "Needs Update", ""), IF([Safety Review Complete]@row = 1, "Prequalified", ""), IF([Financial Review Complete]@row = 1, "Prequalified", ""), IF([Contracts Review Complete]@row = 1, "Prequalified", "")
The first part of the formula works and status changes to "Needs Update" when singled out. But when put together it comes out to #Unparseable.
Am I using the correct function and order? Is there an easier way to do this. Please help!
Best Answer
-
Try this:
=IF(AND([Safety Review Complete]@row = 1, [Financial Review Complete]@row = 1, [Contracts Review Complete]@row = 1), "Prequalified", IF([Expiration Date]@row >= TODAY(), "Needs Update"))
Answers
-
Try this:
=IF(AND([Safety Review Complete]@row = 1, [Financial Review Complete]@row = 1, [Contracts Review Complete]@row = 1), "Prequalified", IF([Expiration Date]@row >= TODAY(), "Needs Update"))
-
It worked! Thank you very much!
Help Article Resources
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
Check out the Formula Handbook template!