%Complete to be automated

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


  • RebSchr
    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)))

  • 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
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!