How to combine cell data from reference sheet.

Jimrny

Jimrny ✭✭✭

04/02/22 in Smartsheet Basics

I would like to combine all notes into my Roster sheet from my reference sheet that has multiple notes. Please assist with my formula.

0 ·

Best Answer

Paul H ✭✭✭✭✭✭

04/02/22 Answer ✓

Should look something like this
=Join(Collect({Notes},{Employee Name},[Employee Name]@row), ",")

0 · Share on Facebook Share on Twitter

Answers

Paul H ✭✭✭✭✭✭

04/02/22 Answer ✓

Should look something like this
=Join(Collect({Notes},{Employee Name},[Employee Name]@row), ",")

0 · Share on Facebook Share on Twitter
Jimrny ✭✭✭

04/04/22

https://community.smartsheet.com/discussion/comment/324847#Comment_324847

Thank you! 🙂

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Do I really have to make the same change on every single one of my sheets separately?
Hi Folks - I'm pretty much a newbie to SS, but I have already created 20+ different sheets for each of my projects, using a template. Now, if I want to make a change to the structure of all the sheets (ie, change the name of a column, add an alert, or anything really!)… is there not a way to automatically make the same…
My automation doesn't send me an email with vertical details; instead I get a very small part of the
I am so frustrated I feel like tearing out my hair! I created this automation: I want to send an email that has all the fields with the information vertical to flow like an email. It worked fine for a week but now I am seeing this: So I only see the first few columns and nothing else. How do I get it back to the way it was…

Help shape the future of Smartsheet.
Share your ideas and feature requests.