=COLLECTMOD([Return Range],"Modify Return Range",[Range 1],"Modify Range 1", "Range 1 Criteria", ...)
Leave blank if there is no modification to the range.
Sign in to see the current vote count, add your own vote, or leave a comment.
If I am reading this correctly, it looks like this is essentially giving us the ability to nest a COLELCT inside of a COLLECT?
Sort of.
The most basic example of:
=join(collectmod(A:A,substitute(@cell,1,2),B:B,,"X"),", ")
Would return:
2, 3, 2, 2, 3, 2
Couldn't you already do that with this?
=SUBSTITUTE(JOIN(COLLECT(A:A, B:B, "X"), ", "), "1", "2")
You're correct. I was trying to think of a way to modify the original value based of the results in the other columns.
Maybe it would be more like
COLLECTMOD([Return Range],"Modify Return Range",[Range 1], "Range 1 Criteria", "Return Range Modifier",...)
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
It would be useful if users who clicked a Dynamic View link (that they were not previously added to) could "request access" to the Dynamic View, and provide a reason, so that the admin can easily grant that access. The use case for me would be to avoid having to pre-populate and then maintain a user group of viewers, but…
As the smartsheet admin for Europe, it would be extremely helpful to be able to view all Automations / recurring emailed reports in one place as opposed to sheet level. It's almost impossible to ensure everything is working correctly / delete recurring emailed reports without this.
