format date and compare it
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";
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
Help Article Resources
Check out the Formula Handbook template!