IF(INDEX(MATCH Function - For Resource Tracking

Hello,

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,

David

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!