IF AND statement using TODAY function also

Options
JaredM
JaredM
edited 12/09/19 in Smartsheet Basics

Hello Community,

I am trying to get "Yes" to appear within a column in the event that a checkbox type column is checked, and the date found in a date column is 7 days old, or older. Here is what I have at the moment:

=IF(AND((Complete2 = 1, "Yes", ""), [Due Date]2 > TODAY() - 7), "Yes", "")

 

Any help with this would be appreciated, thanks!

Comments