Returning Open or Closed based on conditions
Referring to Row 6
I have a Status column and that can be Open or Closed. It depends on the condition of the Progress column which can be selected from the following dropdown menu. The first 4 conditions mean the Action Item is “Open”. The last condition means the Action Item is “Closed”.
Dropdown:
- Not yet submitted
- Submitted for Review
- Submitted for Approval
- Returned to Action Owner
- Approved by Approver
So, I want the Status column to return “Open”, or “Closed” based on the 5 conditions.
Additionally if the Date in the Due Date column has passed I want the return to be “Overdue” rather than “Open”. Overdue is a sub set of “Open”
I tried the following:
=IF(OR(Progress6 = "Not yet submitted", Progress6 = "Submitted for Review", Progress6 = "Submitted for Approval", Progress6 = "Returned to Action Owner"), "Open", “Closed”, IF([Due Date]6 < TODAY(), "Overdue"))
Comments
-
Try something like this...
=IF(Progress@row = "Approved by Approver", "Closed", IF([Due Date]@row < TODAY(), "Overdue", "Open"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!