INDEX COLLECT not working!

edited 11/14/22 in Formulas and Functions

I have an estimate sheet, where I am referencing pricing from another sheet with multiple criteria - trying to use an INDEX with COLLECT formula. Please see screen

shots attached. The formula I am using is:

=INDEX(COLLECT({Rental Cost}, {Equipment Description}, [Equipment Description]@row, {Units}, Units@row, 1))

This returns an Incorrect Argument Set error however. Any ideas why?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!