Index Collect

Hi everyone.

I need to build a sheet based on an approval matrix per function/dep code and differents amounts.

I figured out how to pull data from a cell using Index Match formula to bring the Approver on my target sheet based on the cell "Function/dep code" but now I need to bring the approver based on the amount input in column PO amount. Depending on the amount it would need approval from different people.


I tried using index collect but I kindly ask for help as I do not know how to build it

thanks!

test1.JPG test2.JPG


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!