I want to get to this count

Jlind

As I am trying to build the report it only gives me the option to choose one column, but in that one column are all the values I need to sum up.

Genevieve P.

Hi @Jlind

It looks like you've built a Sheet Summary Report from the Sheet Summary section of a sheet. In this instance each field is seen as a column, so that you could combine the Sheet Summary from multiple sheets and they'd appear in the correct rows below in the Report.

The way to SUM these together would be to have another Sheet Summary Field added to your sheet with a SUM formula:

=SUM([Not Started]#, [In Progress]#, Complete#, Canceled#, [On Hold]#)

Cheers,

Genevieve

Jlind

Thank you so much @Genevieve P. !! It worked for me. :)

Genevieve P.

Wonderful! I'm glad I could help.