If/And, Date

Nicole Hodges

Hello!

Is there a way to checkbox a column if the following two conditions are met:

IF the "Date Opened" date column is one day late AND IF "Date Closed" column is blank.

 

One date late example - Opened 12/3 and not closed on 12/3, I want to checkbox.

Andrée Starå

Hi,

Try this.

=IF(AND([Date Opened]@row = TODAY(-1); [Date Closed]@row = ""); 1)    

The same version but with the below changes for your and others convenience.   =IF(AND([Date Opened]@row = TODAY(-1), [Date Closed]@row = ""), 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Nicole Hodges

Yes! Thank you, Andree!!!

Andrée Starå

Great!

Happy to help!

Best,

Andrée