Unable to determine if a field contains a date less than today's date (involves vlookup).

Hi all,

I am trying to create a helper field to allow me to generate a report of records where the date from a field in my Smartsheet is less than today's date. This will be used to call attention that an update is needed.

The date field being used is a vlookup generated field from another sheet.

Formula: =VLOOKUP([Code]1, {Date_Table Range 14}, 12, false)

The field in the sheet is marked as a date field in both the current sheet and reference sheet.

When I try to use the formula listed below in my new helper field, I get an "#INVALID OPERATION" error:

=IF([Modified Target Completion Date]1 < TODAY(), true, false)

Any ideas?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!