=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",...)
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
