-
Update Requests - New Row
I've set up an automated Update Request with the following fields, Date, Update (text field), Details, Start Date, and End Date. All I'm looking for is for colleagues to provide a weekly update on their projects with it's a simple Date and text update in the Update field or to include the Date (Start or end) fields. I want…
-
Duplicated a Sheet / History is GONE
I duplicated a SHEET and now all of my HISTORY (in cells) are GONE! HELP! I can see the deleted info in the Activity Log and can recreate; however, now it throws and error and won't let me get it back?
-
range checking & flags
Hi, I'm trying to leverage a formula to check if the employee ID is listed on another sheet. Sheet 1 (sanity check): This is where I want the formula to live. On sheet 1, if the employee ID on the row is not listed anywhere on Sheet 2's Employee ID column (range), then turn the flag on. If the employee ID on the row is…
-
Training Registration and Training Tracking
Think of this a little bit like a registrar. We, at New Mexico State University, conduct a year long paraprofessional certification program. *Participants register for the program. *Training consists of a one week introductory, in person, course, followed by six, live zoom training sessions, spread over a year. *The…
-
Can a sheet-only Viewer see Workspace members or other collaborators on the same sheet?
Hi everyone, Quick question about sharing permissions in Smartsheet: If I share a specific sheet only (not the entire workspace) with someone as a Viewer, will they be able to: See the list of people who have access to the workspace itself? See the names of other people who are shared on that same sheet (the collaborators…
-
Intermittent Errors on Column Formula, Report always displaying errors
Why is my sheet intermittently displaying error messages & Report always displaying error messages. One minute the columns have data then randomly they all show up with the error messages? My report consistently ONLY displays error messages. I have a sheet performing calculations related to consumption of water based on a…
-
Formula to Pull In the Sheetname to A Cell?
Hi all. Is there a formula or a way to pull in the name of the open sheet, into a cell on that sheet? Ideally I was thinking something like =sheetname but that's not an available formula.
-
Time columns from Excel to Smartsheet via Data Shuttle
I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns. They look like this in Excel: But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns: I'm really only interested in the time…
-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
Reasons for error code 1008 in webhook subscription request
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…
-
Managing @Mentions
I developed a comprehensive End-to-End Testing platform using Smartsheet. After my client completed their initial 4-week testing cycle, we held a feedback session. One key area they highlighted for improvement was managing the volume of @mentions using conversations they were receiving . They found it challenging to keep…
-
My data shuttle filtering is not correct in upload
upload workflow runs perfectly, but the filter has projects less than 31st march 2025
-
Collecting the most recent submission
Hello, I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column. I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day.…
-
Automation Help Please - Change Cell
Hello smartsheet community! I am basic familiarity with automations. I've created dozens, but they have all been fairly simple. Right now I am working on some automations for our project management templates, specifically our project plans to automatically when a task is delayed. I have created 3 separate automations…
-
Pull data from a row
I'd like to pull data from a Smartsheet row, having designated specific columns, and put it into a document that can be printed.
-
Timeline Zoom out/in & Merged Cells
I am a user of monday.com, and their Gantt timeline allows me to zoom in and out. Smartsheet stays in the same lens now, as the zoom in and out just changes range, but not actual resolution and field of view. With projects spanning over a long period of time, being able to see the whole field is extremely important. Also,…
-
Reaching Cross Reference Max error prematurely
I Saved as New an existing Project Metadata sheet with 90+ cross-references. When I removed the old cross-reference formulas. I was only able to add 6 new cross-references before getting the "Unable to create cross-sheet reference, because this sheet already contains the maximum number of different cross-sheet references"…
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
How to Recover deleted rows and attachments
A user deleted most of the rows and the attachments of a sheet and a few Columns - but not the whole sheet. How do I restore the deleted columns, rows, and attachments into the sheet?
-
K-12 Education
Hello everyone, my name is Alan Miller and I am an Executive Assistant working in K-12 education in Grand Junction, Colorado. I would just like to introduce myself and share some of the uses of Smartsheet that I use within my industry. I have been using Smartsheet for 4 years now and just returned from my second time at…