SUCCESSORS Testing

Amanda O

Hi@Paul Newcome

Thanks for sharing and this is great, as this is something I am looking at, at the moment, did you get to a solution when you have SS or FS in your predecessor?

Paul Newcome

@Amanda OI honestly have not pursued this much since the original testing. I got crazy busy and my solutions rarely use predecessors which meant this had to get shelved for a while.

What exactly are you wanting to accomplish?

Neil Watson

Hi@Paul Newcome

I am trying to amend your solution for my case where the % Complete is a status where "Complete" is selected by the user when the task is done. Can you suggest a solution for this based on your formula below?

=IF(AND([email protected]<> "", [% Complete]@row = 0, SUMIFS([% Complete]:[% Complete], [Next Tasks]:[Next Tasks], HAS(@cell,[email protected]+ "")) = COUNTIFS([Next Tasks]:[Next Tasks], HAS(@cell,[email protected]+ ""))), 1)

Paul Newcome

@Neil沃森Try changing the SUMIFS to a COUNTIFS and evaluating your status column for "Complete".

Neil Watson

Thanks@Paul Newcome, the final version ended up as:

=IF(AND([email protected]<> "",[email protected]<> "Complete", COUNTIFS([Next Tasks]:[Next Tasks], HAS(@cell,[email protected]+ ""), Progress:Progress, "Complete") = COUNTIFS([Next Tasks]:[Next Tasks], HAS(@cell,[email protected]+ ""))), 1)

We have a few tasks that are "SS" (as you mentioned, the above works for "FS") so will work to expand that, it should be relatively easy to track when the FS tasks are showing as "Started"....famous last words?

Vivien Chong

Hi@Paul Newcome, I followed your formula for "Ready to Start" so the next task's owner will be informed once the predecessor task is at 100%.

=IF(AND([email protected]<> "", [% Complete]@row = 0, SUMIFS([% Complete]:[% Complete], Sucessor:Sucessor, HAS(@cell,[email protected]+ "")) = COUNTIFS(Sucessor:Sucessor, HAS(@cell,[email protected]+ ""))), 1)

However, it doesn't reflect the next task correctly. Any idea what went wrong in my scenario?

Paul Newcome

@Vivien ChongWhat exactly do you have in the Successor column?

Vivien Chong

@Paul NewcomeI have this in my Successor column: =JOIN(SUCCESSORS([Task Name]@row), ",")

Vivien Chong

另一个选择我working on, to inform the next task person when predecessor task is completed.

I use this formula for the "NEXT PIC" column:

=IF([email protected]<> "", JOIN(COLLECT([Assigned To]:[Assigned To], Row:Row, HAS([email protected], @cell)), CHAR(10)))

For example: Row 8 successor is row 11, the Assigned To is "57N-Sales".

I have a problem: When the Successor is more than 1, the "NEXT PIC" is empty.

I have allow "multiple contact per cell" for NEXT PIC column.

Any advice / input would be greatly appreciated.

Lisa Matthews

@Paul Newcome

Hello Paul,

I have set up the columns/formulas based on your excellent step-by-step guide. I think I might have missed something, can't figure out what it is. So far, it only works for rows where there is only one successor. How can I adjust the formula to extract the task name for multiple successors?

Thank you for your help.

Paul Newcome

@Lisa MatthewsYou would make the Next Tasks column a multi-select dropdown type column (make sure you are using CHAR(10) as the delimiter in that column formula) and then use a JOIN/COLLECT/HAS to join the task names together.

Lisa Matthews

@Paul Newcome

Thank you so much! I changed the Next Tasks column to a multi-select dropdown type column. The formula is working, for the most part. I'm encountering 2 problems now:

• Tasks which have the actual suffix (FS, SS, FF, SF) and/or lag. Not sure how to adjust the formula to remove these and return the row # only.

• Smartsheet does not like what I am doing. After I change the column type to allow multiple values per cell, Smartsheet will not save my sheet anymore. If I uncheck the column option for "allow multiple values per cell", I am able to save the sheet. Strange. Not sure if you have seen this before?

DonaraJaghinyan

Thank you all for your suggestions and examples.

I wonder if it will be possible to send a notification to the successor that the predecessor activity is complete and that they can proceed to working on their task?

[email protected]

@DonaraJaghinyan- Try adding a Flag column and use a formula like this to trigger the flag when all predecessors are complete and the Successor is ready to start:

=IF(AND([email protected]<> "", [% Complete]@row = 0, SUMIFS([% Complete]:[% Complete], Successors:Successors, HAS(@cell,[email protected]+ "")) = COUNTIFS(Successors:Successors, HAS(@cell,[email protected]+ ""))), 1)'

You can then use this Flag column to trigger notifications.