Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    How to calculate Percent Complete based on multiple columns

    ✭✭
    in Formulas and Functions

    Good afternoon. I am new to Smartsheet. I recently imported a tracking Excel spreadsheet into Smartsheet. I have a existing column that tracks percent complete and the formula is =COUNTA(H4223:AC4223)/SUM(COUNTA(H4223:AC4223)+COUNTBLANK(H4223:AC4223))

    It comes over as unparseable. Can anyone recommend a Smartsheet formula that will mimic this? I attached a copy of the header from my spreadsheet. Most formulas I have looked at track percent complete with parent and child rows and my spreadsheet is set up with columns instead. Any assistance would be most appreciated.

    Header row.xlsx


    · Share on FacebookShare on Twitter

    Answers

    • Overachievers Alumni

      COUNTA & COUNTBLANK aren't available formulas in Smartsheet so I'd recommend using COUNTIF.


      https://help.smartsheet.com/function/countif

      Kelly Drake (she/her/hers)

      STARBUCKS COFFEE COMPANY| business optimization product manager

      · Share on FacebookShare on Twitter
    • ✭✭

      Thank you.

      I tried your suggestion creating the formula below and am still getting unparseable.

      =COUNTIF(Service order Accepted:Complete ISP task in Century)/SUM(COUNTIF(Service Order Accepted:Complete ISP task in Century)+COUNTIF(Service Order Accepted:Complete ISP task in Century)) I might not completely understand what the arguments should be.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions