How would I update a row status based on what has been checkmarked in the same row/multiple columns?

TeeCee

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:

1. Page Created NOT checked, Overall Status ="Not Started"
2. Page Created Checked, Overall Status = "Page Created"
3. Content Entered Checked, Overall Status = "Pending Content Approval"
4. Context Approved Checked, Overall Status = " Pending UX Pass"
5. UX Pass Checked, Overall Status = "Pending Design Pass"
6. Design Pass Checked, Overall Status = "Pending Final Approval"
7. Final Approval Checked, Overall Status = "Ready for Publishing"
8. Page Published Checked, Overall Status = "Complete"

Is this type of update possible?? Looking forward to help/guidance from the community!

Paul Newcome

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.

TeeCee

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"))))

TeeCee

@Paul Newcome is what I'm trying to accomplish possible?

Paul Newcome

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.

TeeCee

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")))))))

Paul Newcome

Happy to help. 👍️