#invalid Column Value Error

Hello Team,

I have a sheet with two columns, one is set as text (referred as NTP on the SS below) and the other one is set as date (NTP Received (A) on the SS below).

I am trying to apply below if formula on another to sheet on a column that is set as date but I get the #Invalid Column Value Error on the ones that are other than N/A.

Please see below SS and advise where I might be doing wrong.

Thank you in advance.

The original Sheet

The other sheet that I am trying to pull from below formula:

=IF(INDEX({4- Planning Range 3}, MATCH([Site Name]@row, {4- Planning Range 2}, 0)) = "Yes", {4- Planning Range 4}, "N/A")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!