Can Smartsheets talk to each other?
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software.
I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid. There are ever-changing statuses to each apprentice's progress in the program. I need to be able to consolidate the information we currently have in multiple Smartsheets, simplify tasks, and use the Smartsheets to their fullest capacity.
Any business managers out there who can lead me in the right direction?
Answers
-
I hope you're well and safe!
I'd recommend to either try using Reports instead or Cross-Sheet Formulas (more info below).
You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you think you need in the Destination sheet.
Would any of those options 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Aimee... Can you be more specific about how you want smartsheet to talk to each other? There are things like linked cells, reports, automation that copy rows to and from one smartsheet to another, and things of that nature.
-
Hallo zusammen,
ich hätte eine ähnlich Frage, und vielleicht kann mir ja jemand einen Tipp geben.
Der DataMesh nimmt mir leider nicht die erste Spalte, also die mit der Zeilennummerierung, zum Synchronisieren mit. Somit gehen Dateianhänge und Kommentare verloren.
Ich habe eine große Datenbank (Smartsheet) aus der mehrere einzelne erstellt werden sollen, über Bericht läuft dann alles wieder zurück in die große Datenbank. Und der Bericht ist notwendig, damit jeder Arbeitsbereich auch nur die Ansicht in in ihrer Karte hat, die sie auch tatsächlich benötigen.
*Hello everyone,
I have a similar question and maybe someone can give me some advice.
Unfortunately, the DataMesh does not take the first column, i.e. the one with the row numbering, with me to synchronize. This means that file attachments and comments are lost.
I have a large database (Smartsheet) from which several individual ones are to be created, everything then runs back into the large database via report. And the report is necessary so that each workspace only has the view in their map that they actually need.
and now I hope that google won't let me down with my translation 😂
Viele Grüße
Sonja
-
Hi @SonjaP.
You are correct, DataMesh only looks at named columns in the grid and not the system columns with attachments or comments.
In this instance, you could use a Copy Row workflow which will copy over the entire row, including attachments, to a different sheet. However there currently isn't a way to "sync" the attachment or conversation columns across multiple sheets.
You would need to build Reports off of the main source sheet instead of multiple sheets. Reports are like a window into the main sheet so they can show those original attachment and comment columns.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 412 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!