-
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
-
Emails sent via Automations not working
Hi, My team uses smartsheet to create and notify our team that a user has opened a ticket. We have noticed that emails that are sent via automations are either extremely delayed (several days in some cases) or not being sent out at all. Has anyone else experienced this? Is this an issue on the servers from the issue…
-
Add support for MCP and custom AI integration
Add first-class support for MCP (Model Context Protocol) to Smartsheet so customers can connect AI assistants and agents to Smartsheet data and actions through a standardized, secure interface. MCP is an open standard for two‑way connections between AI applications and external systems, designed to reduce fragmented,…
-
Issues with Email Automations
We are curious if anyone is experiencing issues with automations that are to generate emails. We've been seeing gaps with a number of these automation on various sheets, where the sheet will record a date of when the email was sent, but it is either never received by the recipients or it is received hours or a day later.…
-
Data shuttle upload error to client sheet with a locked store id column
Seeing if anyone has a similar experience or guidance. We have two sheets which we are using data shuttle between: • Client project tracker • Internal project tracker We have setup matching column names and types, which we want to use data shuttle to communicate updates between our two sheets. We pull unique store numbers,…
-
Changing cell value automatically based on form responses
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
-
How do I "check a box" in one sheet based on criteria from a separate sheet?
Ideal Outcome: I get weekly training reports generated to sheet "x" and when someone is marked as "complete" in the training reports, I want to have a box in sheet "y" be checked. Is there a way to automate this process without copying loads of unnecessary data into the tracking sheet (sheet "y")
-
Make REST API Calls with an Automation
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
-
Automated Dashboard Snapshots & History
Problem: Current Limitations Ephemeral Data: Dashboards are "always live." As soon as the underlying data changes, the previous state of the dashboard is lost forever; there is no native way to view "what the dashboard looked like last Friday." Manual Workarounds: Users must manually use snipping tools or "Print to PDF"…
-
Public links to sheets in automated emails?
I am trying to send non-Smartsheets users information on forms. I know I can create a publicly accessible and editable link for the overall sheet/form, however, when I set up automated emails with links to the forms, the links to sheets/rows still require a login. Is there any way to get around it so that emails sent…