-
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…
-
Mastersheet Linking errors after adding column #unparseable #incorrect argument #blocking
I added a new column to a target sheet. Broke my mastersheet, resulted in #incorrect argument error in all columns with the exception of Primary Column. Went thru checking all column types basic trouble shooting of links couldn't resolve it. I made a new Mastersheet opened "table view", use formula cell linking. Created 4…
-
Index/Match - Primary Sheet to Individual Sheet
Hi Community, I am looking to track training at the individual employee level as well as for my company overall to provide statistics. Currently I have two sheets. One is the primary tracker, and the second is an individual employee sheet (template). The primary tracker has approximately 107 columns, each column represents…
-
Easiest way to vlookup off a file
Hello, I'm new to Smart Sheet. I have an 'intake form' that pulls user-entered data into my Smart Sheet, and one of the fields that is entered I would like to lookup off of a Workspace I uploaded (Excel document). Are there any tips/tricks to help get this done? I linked a cell to it, but then it put a blue arrow and I…
-
Automation and Forms
If i have a Microsoft template that i have to collect information and fill out. If i created a form to collect the information that's needed for the Microsoft Template, Is there a way to utilize the information from the sheet to automatically fill out that template and email it out to respondents on the list?
-
Bi-directional celllinking
Currently, when cell links are created, the updates have to originate from the source cell, and then propagate through the subsequent links. Particularly in a Control Center setup, you can have 3 or more sheets that link (from the intake sheet, to a metadata sheet and then to the project plan, is one example). As an…
-
My entire sheet is showing Invalid Argument Set
Hi! I'm pretty new to Smartsheet so I have no idea what I did or how to fix it. BUT we're using it as in invitation platform for an event we run. On my Registration sheet, it pulls data from the Data Intake Sheet. The Data Intake Sheet had an extra column called Travel Group that the Registration sheet did not have. This…
-
Perpetual dates
I have a formula that will give me a date. However, when the date is < then today, I want to add lets say 80 days or reference another cell. My formula keeps giving me an error and I tried chat GPT, but no dice. Any help would be appreciated 💖🥹 This is my base formula to give me the initial date: This formula is located in…