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.

    Summarization Formula Not Working

    ✭✭✭
    in Formulas and Functions

    I'm trying to create a summary that adds the number of households (HH) for projects in a Construction status. Is it my formula or is this not possible in SS?

    image.png


    · Share on FacebookShare on Twitter

    Answers

    • Community Champion
      edited 02/03/23

      Hello @RBrewster,

      It looks like you are trying to use sum and an if statement to make your formula.

      Smartsheet has a formula that combines the two called SUMIF(). The following formula should help you achieve your desired result.

      =SUMIF([Stage]:[Stage], "Construction", [Homes-Curr]:[Homes-Curr])

      Hope this helps!

      -Christian

      · 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