Index/Match Error

Okay, I am confused by why I am getting this error on my Index/Match formula, so thanks in advance for your assistance. First my error is "Invalid Column Value". I have never seen that error previously, so I am stumped how to proceed. I am doing an Index/Match formula, and I have done multiples of this function, so I am familiar with the format. My formula is on the sheet named QMS Program Metrics (1st screenshot below). And my formula accesses another sheet, Fiscal Quarter Calendar (2nd screenshot below). My formula is:

=INDEX({Days Out}, MATCH(FYQTR@row, {FY QTR}, 0))


Sherry Fox

Project Analyst | Core Quality Services (QMS Transformation)

Medtronic

https://www.linkedin.com/in/sherryfox/

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!