Can I use Summary fields in formula

SueinSpain

I have created some sheet summary fields to count the number of records that meet a specific criteria e.g. Fire Doors - Pass is the summary field and the formula is

=COUNTIFS([Last Month]:[Last Month], ="True", [Fire Doors]:[Fire Doors], ="Yes")

I have done the same for several other fields too e.g. Fire Exit Routes - Pass, MCP - Pass etc.

I now want a total of all the passes and I would like to just add the summary fields together

OR do I have to create one massive formula to add each condition as I have 24 fields?

Not sure if I'm just blind to the solution or you cannot reference summary fields in formula.

I can't see how to do it in a summary report either

Hope someone can help :)

Many thanks

Sue

Scott Peters

Hello @SueinSpain - The formulas in your columns can reference any of your sheet summary fields. If you have a sheet summary field called "doors", then you would refer to it as doors#. If you have a summary field called "Fire Doors", then you would refer to it as [Fire Doors]#

The pound symbol is the key. Hope that helps! Also for reference: https://www.smartsheet.com/template-gallery/formula-handbook

Scott Peters

Hello @SueinSpain - The formulas in your columns can reference any of your sheet summary fields. If you have a sheet summary field called "doors", then you would refer to it as doors#. If you have a summary field called "Fire Doors", then you would refer to it as [Fire Doors]#

The pound symbol is the key. Hope that helps! Also for reference: https://www.smartsheet.com/template-gallery/formula-handbook

SueinSpain

Scott you absolute star - I thought I might be missing something obvious and… obviously I was

THANK YOU