Index(Collect add to formula page

L_123
L_123 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Can we get an index(collect example added to the collect formula page? I have found it extremely useful in finding specific iterations of data, and I only stumbled upon it trying random things to solve a specific issue I had a while back. It could have saved me quite a bit of time if I had seen an example of it when looking at the formula page.

This is the best way I have found to get filtered data between sheets, and I have a feeling that a lot of  users haven't seen this functionality yet.

Thanks!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!