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

Natalia Kataoka

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!

Paul Newcome

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.

Paul Newcome

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.

Natalia Kataoka

Ah ha! I only had a single field selected for my range. Thanks Paul!

Paul Newcome

Happy to help. 👍️

Here is a list of all of the error messages, the reason(s) for each, as well as a little bit of troubleshooting tips...

https://help.smartsheet.com/articles/2476176-formula-error-messages?_ga=2.66067626.529420994.1554725353-1302373248.1552411124