Automate % dependant if cell is blank or has a date
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
Help Article Resources
Check out the Formula Handbook template!