Predecessor formula

Materia174
edited 12/09/19 in Formulas and Functions

help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be output through the filter. But since this is not there, I understand that I need for this formula for each line and I will indicate this in the filter. Example: If Task 1 is not completed and overdue, then all who refer to this task will be in this filter. P.S In the predecessor column, each task may not have one predecessor, but a comma and several

https://i.imgur.com/QIpNHEk.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!