Issue with "Formula To Indicate A Task Is Ready Because Predecessors Are Complete" Solution
So I have tried both the 2 & 6 column version of this solution (see link below), but things are not working as I would expect.
Formula To Indicate A Task Is Ready Because Predecessors Are Complete
The formula is showing rows as "Ready" that should be "Waiting", and I am terribly confused why.
Answers
-
The reason you're seeing "Ready" is because your [Pred Count] is the same as your [Pred Done Count] - they're both 0, so the Ready Status is "Ready"
=IF(COUNT(CHILDREN()) = 0, IF([Pred Done Count]@row = [Pred Count]@row, "Ready", "Waiting"), IF(COUNTIF(CHILDREN(), @cell = "Ready") > 0, "Ready", "Waiting"))
Can I confirm that your [Pred Count] column has this formula:
=COUNTIFS([Row ID Comma]:[Row ID Comma], AND(NOT(ISBLANK(@cell)), FIND(@cell, [Pred Replace FS]@row) > 0))
and that your Row ID Comma column has a value for every single row?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives