-
Global Referance point
I and I think alot of others really need this, We need to be able to have a global reference point so that we can reference across multiple sheets that have that same column . at the moment we can only refence one sheet at a time per formula example: =INDEX({MACH MAT}, MATCH([Row ID]@row, {MACHROWID}, 0)) If i want to find…
-
Cannot turn off "Send as Attachment" in a sheet
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
-
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…
-
Status reports
Has anyone figured out how to easily see overdue tasks in RM or how to pull a report? Side question: Are we any closer to have RM statuses sync to Smartsheet?
-
Click-Through Capabilities for Smartsheet Calendar
When publishing a calendar from the Smartsheet Calendar widget to a dashboard, users can still slick through to a calendar list via the header in the calendar. There should be a way to "lock" the calendar view to a published dashboard that prevents users from clicking-through to other areas. This "locked" calendar should…
-
Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
-
Automated copy row to a new grid
When the automation copy row to new grid when the criteria is triggered; can we make a selection for only x amount of column to be copied and not all columns from the original gird?
-
Seeking ideas and best practices for centralized intake form
The communications and marketing functions at our company recently all merged into one large team. We're now working on creating a new, centralized intake form to capture all incoming requests. However, several functions (e.g., employee comms, graphics, events) have existing Smartsheet forms that they've been using for…
-
👋 Hello from Kentucky! | IT & Manufacturing PM
The Professional Side: I’m a Project Manager in the Manufacturing sector, where precision and timing are the heartbeat of everything we do. My journey started in general project management, but I’ve found my true "geek gear" in the IT and Security space. I’ve made Smartsheet my "single source of truth" for keeping…