How to index using more than one row_index
So I am working on making a list of the successors assignees, so that smartsheet can notify people once the predecessor tasks have been done, I have pulled the list of successors using the formula =JOIN(SUCCESSORS([Task Name]@row), ", ")
and to find the corresponding person to that row I use
=INDEX([Assigned To]:[Assigned To], VALUE(Successors@row))
but this only returns one person's contact, how can I make this in a way to return more than one contact in the same cell?
Thanks
Answers
-
You would have to use the JOIN function, but...
As of right now there is no way to use a formula like this to populate multiple usable contacts in a single cell. It will be output as a text string and will not be a valid contact for automations.
TO alert people when it is time to start their task, you would need to check a box on rows where the predecessor has been completed.
-
I see, Thank you
Also, is there a way to hide the error "#CONTACT EXPECTED" ? I tried the IFERROR formula but it doesn't seem to work here.
Help Article Resources
Categories
Check out the Formula Handbook template!