-
Lengthy text value in dropdown not a pickable option in certain filters
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
-
Automation Rule: Change Status to In Progress Based on % Complete Between 1% and 99%
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…
-
Can automated emails from a sheet be forced to individual emails?
Smartsheet is currently combining my automated emails from multiple lines into a single email. Is there a way to force each line to get its own email? I have column placeholders in the subject and body of the message, but it always combines lines into a single email when the automations are triggered at the same time for…
-
Using Multiple Sheets as Resource Allocation Tool. Allocations not updating based on date changes
Hello! I am trying to use sheets in a resource management type of way without the complexity. I have two sheets I am using. Sheet One: Holds all the resources. It includes allocations based on dates. Sheet Two: Displays summary of allocation. I would like sheet two to update the Total Percent Allocation for each person…
-
Export Column Properties
Is there a way to export the column properties of a sheet ? It would be incredibly beneficial to be able to export the structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only Add contacts…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
-
Smartsheet Setting
In Smartsheet, we can publish a sheet with an open link for anyone to edit. However, this same setting for publishing a report with an open link for anyone to edit is disabled at our enterprise level. Do you know if there is a reasoning for this feature to be disabled for reports but not sheets? Thank you in advance for…
-
System Admin: How to export a list of all Smartsheet assets across the account?
Hi everyone, I am trying to generate a report that lists all assets (Sheets, Dashboards, and Reports) created by users within the same Enterprise account. I have System Admin permissions, and so far I have tried the following: Navigated to Admin Center → User Roles and Reports → Generate reports Selected Sheet Access to…