=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",...)
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Currently, when using Automation to send Update Requests, there is no way to enforce mandatory (required) fields for users completing the request. This creates data quality issues, as users can submit incomplete updates, even when certain fields are critical. Proposed Enhancement Add the ability to mark specific fields as…
