Feature Enhancement Request

L_123
L_123 ✭✭✭✭✭✭

I would like to be able to append/adjust actively sorted values in a range. In other words to be able to handle data more like matrix formulas in excel. Currently this is done with collect, but there isn't a way to change the values being filtered individually. To that end I propose a =collecta() formula.

=COLLECTA({Return Range},"Action to perform",{Criteria Range 1},{Criteria}...)


This could help with various projects and tasks, and would open up more solutions for the program.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!