Automate % dependant if cell is blank or has a date

dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!