IF(INDEX(MATCH Function - For Resource Tracking


I have an Procurement Engagement Form (PEF) and a Resource Tracker. I'm trying to pull the Contract End Date into the Resource Tracker using the Function below.

Its working perfectly in Excel, although unfortunately I'm struggling to get it to work in Smartsheet.

=IF({Procurement Engagement Form Range 3} = "Complete", INDEX({Procurement Engagement Form Range 2}, MATCH([Resource Name]24, {Procurement Engagement Form Range 1}, 0)), "N/A")

Thanks for your help,


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!