Can I make an IF reference in another sheet and then Index / Match?

rosegarretson ✭✭✭✭
edited 11/29/23 in Formulas and Functions


I'm trying to make an IF formula that will look to see if a specific type of equipment is ordered, and if the PO has been issued, then move the checkbox to another sheet with Index / Match.

Here's a simpler one without the IF...

=IFERROR(INDEX({2024 GC and Contractor Sheet - Bids Range 1}, MATCH([WBS@row], {2024 GC and Contractor Sheet - Bids Range 2}, 0)), "")



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!