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
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
-
B
E
A
UTIFUL!
Thank you so much for both options. This was exactly what I needed!
-
I'm glad I could help! 🙂
