%Complete to be automated

justin46491

I am trying to work on my sheet to get the % Completed to be automated.  How can I go about doing this?

RebSchr

Hi there!

I am fairly new to Smartsheet as well and I used logic similar to excel and did a countif and then divide it by a total count.  I used checked boxes for each step and it would update my % Complete for me.

 

Here is the formula that I utilized, but there might be something simpler that I am not aware of.

=(COUNTIF([Scope Complete]2:Done2, <>0) / (COUNT([Scope Complete]2:Done2)))

justin46491

Good Morning,

 

I just tried it and it is not working for what I am looking to do I have target date and completion date.  When I change the information in the formula tabs it comes up with the Unparsable error

 

RebSchr

I wasn't using dates -but you could create a column that gives you the  total days and the total remaining days based on the target.  I am sure you could do this in a formula as well.  My formula was looking to see if multiple columns were greater than 0.