Flag warning if date is after another within same column

harrywhitehouse01

Hi all,

Currently having issues with this:

I need to find a way of flagging a warning (that'll just say "WARNING") in the thirteenth row of the date column if any of the dates in rows 2-12 are after the date in row 1. I am also struggling to find a concise way of flagging a warning in row 14 if there are any duplicates in values between rows 1 and 12. Thank you.

Paul Newcome

Try these:

=IF(MAX(Date2:Date12)> Date1, "WARNING"

=IF(COUNT(DISTINCT(Date1:Date12)) <> 12, "DUPLICATES")

harrywhitehouse01

https://community.smartsheet.com/discussion/comment/335220#Comment_335220

Hi Paul, those work great, thank you. Do you know how I would go about adding that I do not want the warning to appear for the first formula if any of the cells Date1:Date12 are blank? Thank you again.