Formula Predecessor Help 2...
I could use some help. I've implemented J. Craig Williams' predecessor solution allowing notifications based on the predecessor being complete for a given task:
1. Create a column to get your Row# [RowID]
In the first row, put a 1.
The second row, use the formula
=RowID1 +1
and copy that to all the other rows.
2. Create a column to get your predecess [MyPred]
The formula there is
=Predecessors1
for row 1, copy that to all rows.
3. I'm assuming / use a [Status] column as a checkbox.
Manually entered.
4. Create a column call [CheckMyPred] of type Text/Number.
For row 23, this is the formula
=IF(COUNTIFS(RowID:RowID, MyPred23, Status:Status, 1) + IF(ISBLANK(MyPred23), 1) > 0, "start")
Pseudo code
- determine if RowID matches MyPred and Status is checked - if so, value is 1
- determine if MyPred is blank - if so, value is 1
- add the two values together
- value will be
0 MyPred is not blank and for the row where RowID matches MyPred, status is not checked.
1 MyPred is blank OR MyPred is not blank and row where RowID matches MyPred, status is checked.
- check if value is greater than 0 - if so text is "start"
What I need help with is Making this work with multiple predecessors and leads and lags.
Any ideas?
Thanks
Robert Meisch
Comments
-
Hi Robert,
You'd likely need to expand your formulas to include text functions that parse through the characters of your predecessors and return a value. This is tricky, but doable. More info on our text functions can be found here: https://help.smartsheet.com/functions (narrow the view to Text in the dropdown).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!