Percentage complete of blank/not blank dates in a column

noclue
noclue ✭✭
edited 12/09/19 in Smartsheet Basics

I am looking for a formula that can show me a percentage of blank cells/non blank cells in a column. 

Ex: My Column is titled: CPD Complete Date.

      There are 10 cells in the column

       Only 5 of the cells have dates

I would like a formula that can show this is column is 50% completed based on how many blank cells there are to how many dates are filled in. 

Is this possible? Thanks!

Comments