Add Two Summary Fields To A Cell
Hello and thank you in advance for any help you might be able to offer.
I'm just getting going in smartsheet. I've built my first sheet with Summary Fields (brief pause while I pat myself on the back). I'd like to take those summary fields and auto-fill cells in the sheet.
I've figured out how to do it with one summary. =[summary]#. But how do I populate two summary fields into one cell? Preferably separated by a comma. But I'll take whatever I can get. For example, =[summaryA]#, [summaryB]#.
Best Answer
-
Hi @Steve_G
Well-done for creating Summary Fields in your first sheet! 👏👏👏
You can add multiple cell values together with the + symbol in formulas, and you can add spaces, commas, text, etc by using + and quotes, like so:
=[summaryA]# + ", " + [summaryB]#
See: Create and Edit Formulas in Smartsheet
If you want to have the values on two separate lines, you can add in a Return by using CHAR(10) in your formula, like so:
=[summaryA]# + CHAR(10) + [summaryB]#
Then if you wrap-text the cell with the formatting tool at the top of the sheet the contents will appear in the same cell but above/below each other.
Cheers!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hi @Steve_G
Well-done for creating Summary Fields in your first sheet! 👏👏👏
You can add multiple cell values together with the + symbol in formulas, and you can add spaces, commas, text, etc by using + and quotes, like so:
=[summaryA]# + ", " + [summaryB]#
See: Create and Edit Formulas in Smartsheet
If you want to have the values on two separate lines, you can add in a Return by using CHAR(10) in your formula, like so:
=[summaryA]# + CHAR(10) + [summaryB]#
Then if you wrap-text the cell with the formatting tool at the top of the sheet the contents will appear in the same cell but above/below each other.
Cheers!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
B
E
A
UTIFUL!
Thank you so much for both options. This was exactly what I needed!
-
I'm glad I could help! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives