-
Hello Everyone! About Me:
Hello everyone! My name is Kacie, and I currently work as a medical assistant. Recently, I’ve taken the lead on transitioning several of our projects into Smartsheet, and it’s been exciting to see how much more organized and efficient our workflows have become. I’m really looking forward to being part of this group,…
-
Include Project Settings Non-Working Days Data in API
We currently use the API below in an automation that creates a duplicate sheet of a template we created. All of the formatting and data is duplicated using the API, but updated Non-Working Days in the template is not making it's way into the new sheet. Please include support for updated Non-Working Days data to passed via…
-
Highlight Changes Feature
When multiple collaborators are working in the same Smartsheet and the Highlight Changes feature is turned on and set to “I last viewed this sheet,” will the highlighted changes only appear for the first person who opens the sheet, or will each user see highlight changes based on the last time they viewed it? I am unable…
-
Contact Columns ≠ Consistent Data
The Core Issue with Contact Columns Smartsheet Contact columns are fundamentally not reliable because they don’t represent people consistently. The same person can appear as a name in one place and an email address in another, depending on user status, permissions, ownership, or whether the data is viewed in a sheet,…
-
Smartsheet formula saving error
I have been using a formula in smartsheet column however from last week i have tried to update the formula and when i save the sheet the following happens please help as soon as possible
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
-
My Sort Option is Greyed Out
Hello, For some reason, I am unable to sort my columns. I am attempting to sort my first column alphabetically. When I right click on the columns (any) the sort option it greyed out. My other column have drop down settings. I appreciate any help!
-
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…
-
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…