-
Inquiry on Smartsheet API update Requirements by this June 3rd.
As per the mail sent by Smartsheet team (June 3rd Deprecation), we verified that below API end points were not the part of the provided deprecated APIs. But cross verifying again, please help us to verify the impact of the below end points. a.Get Sheet – GET /sheets/{sheetId} b.Rename Sheet- PUT /sheets/{sheetId} c.Copy…
-
Automation Infinite Loop Error
Hello, I created an automation so that my Status column automatically changes when my % Complete column changes. Basically, the automations are the following: If % Complete = 0% then Status = Not Started If % Complete > 1% and <99% then Status = In Progress If % Complete = 100% then Status = Complete My automation runs…
-
How To Turn Checkmarks Into Bar Graph
I have 20 inspection locations and a rotate employees to inspect them monthly. Assignments are due every third Wednesday of the month. I manually check assignments that are turned in and manually create a bar graph to show the percentages of assignments turned in that month. Is there a formula to automate monthly…
-
Celebrate our newest Community Champions! [February 2026] 🏆
It's a big day! If you attended one of our Jumpstart 2026 Festival virtual events last week, you got the early scoop, and now we're singing it from the rooftops: New Community Champions have joined the program! Please give claps, snaps, or taps to: @Alan Miller 11 @Akblevins @AngB789 @Cassi @Cayla Davis @Eric B. @Jgorsich…
-
Ability to apply a default formula to a column, but allow manual overrides on individual cells.
We need the ability to apply a default formula to a column (such as =[Request Date]@row + 7), but allow users to override the result on a row-by-row basis when needed. Currently, if we use a Column Formula, it locks the entire column and users can't make exceptions or input a different value in one row. If we remove the…
-
Pull prices through to a sheet using a date range to keep historical data
I have 2 sheets, a Price Register sheet and a Delivery sheet. I want to pull the prices per tonne from the price register sheet into the delivery sheet if the Supplier and description match, and the price is current. I have rows to show old prices between, say 01/01/2026 and 10/03/2026, then a new price starts on…
-
Duplicate emails from automated workflows
This discussion was created from comments split from: Automation Suddenly Sending Duplicate Update Requests (No Workflow Changes Made).
-
What Smartsheet templates are you using for clinical trial tracking?
Hey guys. Currently, I’m in clinical operations. I got a bunch of Phase II & III clinical trials in Smartsheet. We moved from Excel a few months back and still don't know the best way to set things up! The main difficulties I encounter are as follows: Tracking site activation in multiple states it's too dark Enrolling…
-
Hide/Unhide columns for different users
This discussion was created from comments split from: Table view initial release is now generally available for all customers!.
-
How to prevent entire Gantt timeline from shifting when updating activity dates? (Float reduction instead)
Hi everyone, I’m looking for some guidance on how Smartsheet handles float and dependencies in a Gantt project schedule. I’ve built a Gantt plan with several tasks linked through dependencies, and I can see the calculated float/slack between activities. When a small delay occurs on one activity, I update the start date to…