How would I update a row status based on what has been checkmarked in the same row/multiple columns?
Hi everyone! Need some help with this one, I've been stuck on it for days! Essentially what I'd like to happen is we are having a process that must happen in chronological order (starting at Page Created to the right). What we'd like to accomplish is the Overall Status to update based on what has been completed (check marked).
So breaking it down:
- Page Created NOT checked, Overall Status ="Not Started"
- Page Created Checked, Overall Status = "Page Created"
- Content Entered Checked, Overall Status = "Pending Content Approval"
- Context Approved Checked, Overall Status = " Pending UX Pass"
- UX Pass Checked, Overall Status = "Pending Design Pass"
- Design Pass Checked, Overall Status = "Pending Final Approval"
- Final Approval Checked, Overall Status = "Ready for Publishing"
- Page Published Checked, Overall Status = "Complete"
Is this type of update possible?? Looking forward to help/guidance from the community!
Best Answer
-
You would need to reverse the order of your IF statements. Nested IFs work from left to right and stop at the first true value.
If that nested IF formula becomes too unmanageable, let me know. There are other solutions as well.
Answers
-
When I used this formula, the first box (Page Created) overrides the other checked boxes.
=IF([Page Created]@row = "True", "Awaiting Content", IF([Content Entered]@row = "true", "Pending Content Approval", IF([Content Approved]@row = "true", "Pending UX Pass", IF([UX Pass]@row = "true", "Pending Design Pass"))))
-
@Paul Newcome is what I'm trying to accomplish possible?
-
You would need to reverse the order of your IF statements. Nested IFs work from left to right and stop at the first true value.
If that nested IF formula becomes too unmanageable, let me know. There are other solutions as well.
-
Thanks so much!
That worked:
=IF([Page Published]@row = "true", "Complete", IF([Final Approval]@row = "true", "Ready for Publishing", IF([Design Pass]@row = "true", "Pending Final Approval", IF([UX Pass]@row = "true", "Pending Design Pass", IF([Content Approved]@row = "true", "Pending UX Pass", IF([Content Entered]@row = "true", "Pending Content Approval", IF([Page Created]@row = "true", "Page Created - Awaiting Content", "Not Started")))))))
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 60 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!