Automate % dependant if cell is blank or has a date

dave.mcpherson56751 · 05/13/19

Hi, i am looking for some help please.

I have a % complete column that i want to automate to 100% if a date in another column has a date in, but also return 0% if the date column is blank.

I feel this should be easy but am struggling and would appreciate any help.

Thank you as always

Dave

Andrée Starå · 05/13/19

Hi Dave,

Try something like this.

=IF(ISDATE(Date@row); 1; IF(ISBLANK(Date@row); 0))

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

=IF(ISDATE(Datee@row), 1, IF(ISBLANK(Datee@row), 0))

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

dave.mcpherson56751 · 05/13/19

Hi Andree,

that works fantastic, thank you so much.

Regards

Dave

Andrée Starå · 05/13/19

Excellent!

Happy to help!

Best,

Andrée

Comments