how to apply and if/and formula the works of a date but is not blank?

Brandon Morales

Hi, below i have a formula im using to check a box once a date is old enough. unfortunately it also checks the box when there is no date. How can i create a formula that checks the box when date is older than 270 days but not when the date is blank?

Paul Newcome

It would looks something like this:

=IF(AND([Date Column]@row <> "", [Date Column]@row <= TODAY(-270)), 1)

Paul Newcome

It would looks something like this:

=IF(AND([Date Column]@row <> "", [Date Column]@row <= TODAY(-270)), 1)

Brandon Morales

that did the trick- thank you!

Paul Newcome

Happy to help. 👍️