if - and formulas auto populating checkbox

rmpedro68986 · 11/15/18

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å · 11/15/18

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 · 11/15/18

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

Andrée Starå · 11/15/18

Great!

Happy to help!

Best,

Andrée

if - and formulas auto populating checkbox

Comments

Help Article Resources

Categories