Predecessor formula

Materia174

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

Alejandra

Hi Materia174,

I don't have an example of a formula that will help you accomplish this, but when you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to see this functionality with filters in Smartsheet.