How to write a formula that checks the status of predecessor rows?
I'm looking to create a formula that will automatically update a row's status column to 'Ready to Begin' so long as the status of all of that row's predecessors are marked as complete. So for example:
In this case, I'd like lines 7 and 8 have their Status column automatically update to "Ready to Begin" because their predecessor (line 6) has been marked as "Complete".
Can someone tell me if there's a formula function that works this way? Thank you!
Help Article Resources
Check out the Formula Handbook template!