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

  • Genevieve P.
    Genevieve P. Employee
    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