Multi-step formula help needed

What formula could I use to count how many GWS divisions are in progress during the year 2022? This is the formula I have but it is not working. Thanks in advance for the help. Dina

=SUMIF({Helix Migration Plan Range 3}, 2022, (SUMIF({{Helix Migration Plan Range 5} ,"In Progress",{Helix Migration Plan Range 4}})))


  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭

    Hi @Dina Elmore

    This should work, you may need to amend as this formula is written within the sheet. so not referencing the ranges etc.

    =SUMIFS([GWS Divisions]:[GWS Divisions], [Completion status]:[Completion status], "In Progress", [Planned completion year]:[Planned completion year], "2022")

    Hope it helps



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!