Summarization Formula Not Working


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?


  • Christian Graf
    Christian Graf ✭✭✭✭✭
    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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!