Predecessor formula Help
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
Comments
-
I have a few ideas, but I need to do some further testing on them. I'll get back to you on this.
-
Thank you very much.
It's just difficult for me because most likely there will be more than one formula that compares the "Predecessors" and the "Followers" among themselves, given that the predecessors can be several in one line separated by commas.
My idea is that if I see a task that is in the risk zone and should end in a couple of days, I will quickly understand what other tasks it will affect and I can predict the consequences or prevent the consequences on future tasks of the Followers by changing their workload.
-
Hi you say need some test and help me.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!