-
Trying to return a value once, but not when cell value changes
Sorry I don't really know how to phrase this. Basically in the projects we have, we get a quote from a vendor, and they automatically enter it into our project sheets. Because this can change to a lower price or cancelled altogether we set up automation so our price column changes to the lower cost, or to zero if…
-
Editing Widgets - Changing Series Labels on Dashboard
Hello, I'm fairly new to Smartsheet and tried my best research this question prior to asking it here. I've creating a Dashboard and everything is working smoothly, except I realized that the dashboard pulls the 'Column Title' as the 'Series Label Text' for all charts. This would make sense if we were using the data for…
-
How to create create an audit workbook for a team of 20
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Dashboarding an Org Chart?
Hi all, I was doing some research and it does not appear there's a straight forward "Org Chart" template (I've viewed the article Create Organizational Charts in Excel | Smartsheet), which we could maybe display on a dashboard. Our project portfolio reporting has been structured to summarize on dashboards, which start from…
-
Dashboard Chart Types?
Hello I've scoured the online resources up and down and cant seem where to find the ability to add various chart types in a Dashboard. Appears I only have access to vertical column chart.... Never had an issue with this in the past but the dashboard UI seems to have changed altogether. I hope these weren't deprecated... A…
-
Best way to carry out teams audit and monitor progress
Hi, Smartsheet community, I am new to smartsheet and have been tasked with a project to conduct an "as-is" process audit. at least 20 functional teams will be involved in this process. Because the teams have different functions, I'll like to give them the flexibility to duplicate all questions around each activity they…
-
Is it possible to add a link to a smartsheet item as view only?
I have one master sheet (my department overview) into which I want to add links to dashboards in multiple other workspaces (one per project). I have one row per project and it is very simple to right click, add hyperlink and choose smartsheet item, then simply select the workspace and dashboard for the project. However, I…
-
What's with the "unnamed series" in the pie chart?
So I've created a pie chart in my Dashboard and let's say I have basic data such as: Apples 5 Oranges 12 Bananas 8 Blueberries 20 Strawberries 3 Rasberries 19 With this data, when I tried to import it as shown above, it gave me an error. When I imported only the values/numbers, it worked. However, now I cannot show which…
-
missing source appearing on Dashboard
A dashboard that I use daily now appears with "missing source" in a number of places and I have double checked the source is not missing and I am the owner of the dashboard and the source as they appear in the same workspace?! This issue appears since the latest relaese! Has anyone else experienced issues since the new…
-
Publishing a dashboard with embeded code. Error: "The sheet you are trying to publish is no longer..
I am trying to publish a dashboard with embeded code into a sharepoint site and I get the error "The sheet you are trying to publish is no longer published. Please contact the owner" I am the owner and the link of publishing is ON. Also tried to do it many times by turning OFF/ON getting the link again. Do I need to change…
