-
Target range in graphs
I would like to be able to have a highlighted/shaded section on a graph indicating the target range desired for the data being displayed in the graph. For example, The graph is depicting the average number of patient's seen per therapist per shift… the target range is 6-8…. is it possible to have a shaded line parallel to…
-
Make sheet data available to external 'viewers' but limited to only their data
Good morning Smartsheet community. I have been using Smartsheet in my job as the office manager for a small business. I'm self taught and have managed to get some workflow and automations working through trial and error. However, I am stumped on the next project that I'm trying to figure out how to best handle inside…
-
Receive Notification for Broken Dashboards Not Pulling Data
I have 2 thoughts… When a report/sheet name is changed, any dashboards that pull data from that report/sheet also keep that name change so that dashboards do not need to be updated with new file name when changing the corresponding report/sheet name. I would like to receive an email notification if a dashboard breaks so I…
-
Sum(Children()) Formula Issue
My sum(children()) formula in the first row is resulting into zero. Idk why although I tried to double check that the numbers are formatted correctly. any assistance is appreciated.
-
Can you make a dropdown option dependent upon another drop down? Parent / child
Hi, I am trying to setup 2 drop downs in a grid sheet. The user will select from the first dropdown (parent) A, B, C and based upon what they select i only want to show the corresponding options in the second dropdown (child). So for A show 1, 2, or 3 For B show 4, 5, or 6 For C show 7, 8, or 9 . Using a form is not an…
-
Move the Deleted function to another section
Please move the Delete function away from the Edit function for a row in a worksheet. THIS CAUSES A LOT OF ISSUES JUST BY BEING NEAR EACH OTHER!!! Locking rows isn't an option, unless you can tell me if I can lock only certain columns.
-
When using the Workflow for deletions
When using the workflow "Alert someone when a row is deleted," it would be nice if we could have some of the information from that row in the message. For instance, I have an alert setup for deletions, however, it isn't able to capture the Request Title or ID number, because those fields are deleted when a row is deleted.…
-
How to Phrase a Question for the AI or Write the Formula for Myself for Grouping Data
Hello, I would like to see if anyone can help me parse entries across different columns. What I have in my SS is a list of registration numbers in Column A and departmental associations in Column B. I would like to count how many different registration numbers appear in Column A and then group them by their departments in…
-
How to create Icons into a Dashboard
Wondering if anyone knows how to include a link on a Dashboard to other Smartsheet grids/ reports with icons (not just a list)- here's an example :
-
Fix PDF print function with Latin Extended letters
After a helpless few months of knocking on Smartsheet support doors, our company finally got the answer, to why our texts randomly change from set conditions in PDF forms (font, font size, font weight), to a different text. As it seems, if the text in a cell has any Latin Extended letters (ą, č, ę, ė, į, š, ų....), it will…