I'm summarising and want to count a Project Status columns

Have a sheet per colleague and want to do formula that would add up how many On HOLD projects there in total across all of those colleague sheets?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    I would suggest having the total on each of the individual sheets and then cell linking to the master sheet. Then you can use a basic SUM function on the master sheet.

    If you wanted to go with a single formula to reference all sheets, then you would start off with your COUNTIFS for one sheet, then replicate it for the second sheet and add them together, then add a third COUNTIFS for the third sheet, so on and so forth:

    =COUNTIFS({First Sheet}, "On Hold") + COUNTIFS({Second Sheet}, "On Hold") + COUNTIFS({Third Sheet}, On Hold")..........................


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!