if - and formulas auto populating checkbox

rmpedro68986

I've created a column titled "Outstanding Approvals", I would like the column to auto populate the check box when "Approval Status" is empty AND when "Start Date" has already begun. I'm using it so I can pull multiple sheets into a single report - but not all the sheets have the same layout.

Any help is great! thanks in advance. 

Andrée Starå

Hi,

Try this.

=IF(AND([Approval Status]@row = ""; [Start Date]@row >= TODAY()); 1)    

The same version but with the below changes for your and others convenience.  

=IF(AND([Approval Status]@row = "", [Start Date]@row >= TODAY()), 1)

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

I hope this helps you!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

rmpedro68986

Worked Perfectly, the > sign just needed to be changed to < sign to formulate the dates I needed correctly. Thank you!!

Andrée Starå

Great!

Happy to help!

Best,

Andrée