-
Carry over info from one sheet to another
Hello all, I have a source sheet that i trigger an form from another sheet (i embedded the form link to the email). My issue now is that i need to get the ReqID (from source) and have it read only in the new form, that will record in the destination sheet. Bottom line i need to find a way to link the ReqID from source and…
-
Cell Links Between Sheets Don't Work Consistently
Hi - I have set data mesh cell links between multiple SmartSheets that I own. The properties of the columns on the different sheets match. In the Data Mesh set up, I've selected: To overwrite content To create cell links To run immediately I have multiple instances where data changes on the source sheet and does not update…
-
Linking another Sheet
Hi All, I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some…
-
Desired target sheet for "Reference Another Sheet" is grayed out!
I'm attempting to add a reference to another sheet (via Reference Another Sheet), yet the sheet is grayed out. It is in the same workspace, and I have Admin access to the full workspace, including when I check this specific sheet. None of the other sheets in the workspace are grayed out. It has to be something with this…
-
Helping Users Understand How Data Flows
We've recently rolled out a PMO solution and are still in the adoption phase. One question I keep getting is how to update Project metadata (such as start/end date). I have to keep pointing people to the Intake sheet. They've been trained on this, but not all training is going to stick. Is this just a matter of repeating…
-
Multi-row intake form
Hello , is there any way you can have multiple row entries in a single intake form?
-
Share a Report sheet without needing to share the Source sheet
I have a source sheet where data from multiple vendors are present. I would like to share vendor specific data from the source sheet to each individual vendor without sharing sensitive data from the source sheet (data from other vendors). Currently I have a Report sheet that is pre-filtered to the specific vendor, but…
-
How can I combine grid data and Sheet Summary fields into one editable grid sheet?
I have a Sheet Summary Report that pulls data from 48 individual sheets — this includes both the row-level grid data and each sheet’s Sheet Summary fields. I want to have all of this information (both grid and summary data) together in a regular grid sheet, so I can format it, add formulas, and use it in dashboards more…
-
Graphs on a Dashboard - Data selection and display
I am working on a dashboard that shows graphs from a constantly updating subset of data. Data is pushed from Snowflake into Smartsheet via a python script. Ive had trouble creating graphs on my dashboard due to the fact that I cannot select columns as a data set since my dataset grows and shrinks (Graphs only let me select…
-
Expand The Manage References Pop-Up Menu
When managing references in a sheet, the menu that pops up to begin editing/duplicating/deleting cross-sheet references is incredibly hard to work with. The box that pops up does not allow the user to expand the bounds of the menu - vertically, horizontally, or diagonally. Ideally, building the menu out with functionality…