Is it possible to have multiple return ranges located in multiple forms with INDEX COLLECT?

For example, pulling from one other sheet will use the following:

=index(collect(return RANGE, criteria RANGE 1, criteria 1, ,1)

I am looking for the INDEX COLLECT function to return values from multiple sheets depending on if the criteria range matches my @row. This will be the only criteria I search on.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!