Sum of texts in several columns

rago74186
rago74186 ✭✭
edited 08/07/23 in Formulas and Functions

E possibile sommare in una colonna più testi di più colonne di un altro foglio cosa che faccio regolarmente all'interno di un unico foglio

Translated by a moderator

It is possible to add in one column several texts from several columns of another sheet - which I do regularly within a single sheet

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @rago74186

    I hope you're well and safe!

    Yes, and I'd recommend combining the information in the Source sheet in a so-called helper column first and then using a cross-sheet formula to collect it back to the Destination sheet. You'd use something like an INDEX/MATCH combination.

    Make sense?

    Would that work/help?

    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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!