IF(INDEX(MATCH Function - For Resource Tracking

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

Sign In or Register to comment.