format date and compare it

Options

Hello Smartsheet Experts,

I would like to compare a date in my column A with the date 10/12/2020. If it is before the date than it should show up as NEW.

The problem is that the dates "article creation date" have a different format (coming out of a system).


Here are the 2 formats I have in "article creation date";

2018-01-15

1/15/2018 10:10:17

I tried this but it's works only for the cell with this format 2018-01-15, for the other cell I get "invalid operation".

=IF([article creation date]@row < DATE(2020, 12, 1), "", "NEW")

Would be great if somebody could help me?

Thanks and Regards

Christine

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!