SUCCESSORS Testing
Comments
-
@Paul Newcome this is fantastic, just ran across it and it is EXACTLY what I was looking for. Thank you for being such a champion on the Community. Hopefully I can find time to swing by and say hi at Engage 2023.
-
@Brian_Richardson Glad my thread could help although there were some other contributors on this one.
As for meeting up, I will be at the Champion/Overachiever get together Monday evening if you are unable to attend. Otherwise I will be spending the majority of my time at my Partner Booth which will be just diagonal from the Community Booth.
-
See you Monday :-)
-
Hi @Paul Newcome -
Thank you so much for all of this. I'm stuck however as I keep getting an unparseable error.
The formula I now have in the "ready to start column" is: =IF(AND(Predecessors@row <> "", Status@row <> "Complete", COUNTIFS([Next Tasks]:[Next Tasks], HAS(@cell, Row@row + ""), Status:Status, "Complete") = COUNTIFS([Next Tasks]:[Next Tasks], HAS(@cell, Row@row + ""))), 1)
I'm using the status column and "complete" to have it move on. It seems like it works fine for the latest predecessor... but if another down the chain is complete then the check mark disappears... so for example if I have 12>13>14 for linkages and I have 12 complete then 13 will check. But the minute I mark 13 complete the 13 check disappears and only 14 is checked.
I'm brand new to smartsheet so I'm completely lost.
Thanks!
-
@Paul Newcome - This thread and its comments are outstanding, thank you! Like @Vivien Chong, I am using this principle to identify my Next Assignee ("Assigned to" field). Since we all appear to be blocked when it comes to referencing data where more than one Successor exists, is there a way to call out this risk via error text? I envision an amendment to my existing formula that identifies when a comma exists in the Successor field to say "Multiple", I just don't know where to start. Here's my formula...
=IF(Successor@row <> "", JOIN(COLLECT([Assigned To]:[Assigned To], Row:Row, HAS(Successor@row, @cell)), CHAR(10)))
-
UPDATE: @Genevieve P. helped me solve this use case:
=IF(FIND(",", Successor@row) > 0, "Multiple", IF(Successor@row = "", "None", JOIN(COLLECT([Assigned To]:[Assigned To], Row:Row, HAS(Successor@row, @cell)), CHAR(10))))