Can sheet summary field formulas add existing fields?
I have a series of formulas using the sheet summary function. Is it possible to have a formula that just adds two sheet summary fields? For example, if one of my fields is Sum of A, and another is Sum of B, can I create a new formula that just adds Sum of Column A and Sum of Column B? That would be a lot simpler than creating a new formula that accomplishes what the individual formulas each achieves.
Best Answer

Hi @jomansfi87106.
You can reference sheet summary fields in your sheet cells by using the "#" symbol at the end (the same as you would @row or a row number)
Something like =[Sum of A]# + [Sum of B]# should work assuming you already have the sheet summary fields created.
Answers

Yes, you can probably combine the two formulas in one field instead.
What are the formulas you want to add together as one?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi @jomansfi87106.
You can reference sheet summary fields in your sheet cells by using the "#" symbol at the end (the same as you would @row or a row number)
Something like =[Sum of A]# + [Sum of B]# should work assuming you already have the sheet summary fields created.

I'll give that a try, that sounds like what I was hoping was possible! Thanks to you both.

Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!