Determine proof dates based on asset lead times

Pam Dunn

Hi Paul

In regards to the formula I should be entering the column names for the 1st column and last column within the [ ] for my range of columns I want to match correct?

=[Base Date]@row + INDEX({Other Sheet # Of Days Column}, MATCH(JOIN(COLLECT([ADS Assets]@row:[Executive Requests]@row, [ADS Assets]@row:[Executive Requests]@row, @cell <> "")), {Other Sheet Asset Type Column}, 0))

Pam Dunn

I have gotten it to work. I removed the [Base Date]@row because I only need the # of days and then I have another formula to calculate a due date. Thank you so much

Paul Newcome

Glad you were able to get it working. Happy to help. 👍️

Pam Dunn

Success the formula worked. I eliminated the [Base Date]@row I only need to pull in the # of days, then I'm using that cell to complete formula to determine a due date. Thank You so much for your assistance.