-
Select a Destination Sheet Error
Hi all, I know this has been asked hundreds of times, but I cannot seem to find an answer on what to do when the Select a Destination window just displays an error message. I have tried everything from restarting my computer and browser, using a different browser and private window, and clearing all cookies. I submitted a…
-
Copy Single Cell to Cross reference sheet
We’re using a portfolio management tracker. When a dropdown field in the Regulatory column is set to anything other than “N/A,” I want to automatically copy just the Initiative Name, Regulatory Dropdown, and Owner columns to a different sheet in the same workspace. I do not want to copy all columns—only these specific…
-
Update Request sending individual emails instead of one link, even when time based
Hi all, I have an automation that sends me a daily update request for students that have appointments that day, so that I can enter dates and notes. Most days I have 6-8 students. I was (at one point) able to get it to send a mass update request. One link for all the students that had appointments that day. But this…
-
Request for Enhanced Hyperlink Functionality in Automated Notifications
Currently, when adding a hyperlink in an automated notification or alert, the only method available is to insert the full visible URL, like "http://salesforce.com". We need a feature that allows embedding the URL behind text, such as "Click here to go to Salesforce." Additionally, hyperlinks included in automation messages…
-
Number of Days from a given date against the current date
I need to get the number of days ( just a number ) from a given date against the current date. I need to know Column 2, to show the number of days to the coloumn 1. Ex: Column 1: ( ETD ) 28/02/26 Column 2: (Number of Days to ETD ) 5 ( if the current date is 23/02/26 )
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an attachment. Currently my trigger for the workflow is when the data in a certain field…
-
Cross referencing same range across multiple sheets
I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Feature Request: API - Ability to Enable+Disable Automations
FEATURE: Add the ability to enable and disable all sheet automations via the Smartsheet API. THE REASON THIS SHOULD BE IMPLEMENTED: When a workspace or sheet is duplicated the automations all remain active. So if "Save as New" is used as a backup method, time-based automations will also duplicate. As a result, if there are…
-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…