%Complete to be automated

justin46491
justin46491 ✭
edited 12/09/19 in Formulas and Functions

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

Tags:
· Share on FacebookShare on Twitter

Comments

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

    · Share on FacebookShare on Twitter
  • justin46491
    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

     

    · Share on FacebookShare on Twitter
  • 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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!