-
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…
-
Dashboard Metric Widget White Space
I'm working with a metric widget in a dashboard and I'd like to minimize the amount of white space that appears between the label and the data/information presented. If I make the widget narrower the white space decreases but then there isn't sufficient space or the information that needs to be presented. Is there any…
-
Can't plot data eventhough I have access
Hello, I have troubles plotting the data of a certain smartsheet. I tried copying it from the smartsheet as well as recreating the chart from scratch. Nothing seems to work. Any ideas? Data source is a filtered report.
-
Sheet Summary Report with Dropdown
I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it's returning blank in the report. The source data is a project management / Gantt…
-
Dashboard- weekly project status submissions
Hi, I would like to create a monthly dashboard that displays which project managers have submitted their status each week. I have a master Project Management Sheet where project managers submit their status. I plan to have an automation that clears whatever the project manager has added , in order to make room for their…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
