Formula help: Check box if field in another sheet is a date

I am attempting to use an IF statement with an Index(Match( to check a box in my target sheet if a matching field in my reference sheet is a date.

I am attempting to match the Vendor Names between the two sheets and have used the below formula but am getting a #NOMATCH error.

=IF(ISDATE(INDEX({Contract Management - Sub notification}, MATCH([Vendor Name]@row, {Contract Management - Vendor}, 0))), 1, 0)

Reference sheet:

Target sheet:

Any help appreciated!


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Based on that particular error, I would start by double checking the data in the [Vendor Name] columns on both sheets. While it appears they are the same, Smartsheet only displays a single space. OS if you have 20 spaces between Coastal and Mountain in one sheet and the other sheet only has one space between the two words, it will still appear the same until you actual open the cell to edit.

    If the text strings are in fact exactly the same after opening each cell to verify, double check that your Contract Management - Vendor} range is covering the appropriate column.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!