Can I check a box based on a column date and if another column is not blank?

Brandon Morales

Hi, I'm trying to check a box when today is greater than my column date and when my column date is not blank. Right now it checks any row where the column is blank and I don't want that- any ideas?

Paul Newcome

You would use the AND function.

=IF(AND([Expected Usage Date]@row <> "", [Expected Usage Date]@row < TODAY()), 1)

<> ""

or

<> quote quote

essentially means "is not equal to blank".

Paul Newcome

You would use the AND function.

=IF(AND([Expected Usage Date]@row <> "", [Expected Usage Date]@row < TODAY()), 1)

<> ""

or

<> quote quote

essentially means "is not equal to blank".

Brandon Morales

That did the trick- Thank you!

Paul Newcome

Happy to help. 👍️