-
Collaboration of Project Plans
Hi We are using smartsheet to manage all of our customers onboarding projects in the Professionals Services department. We have global team that share resources globally. What are the best practices we should use in order to share all projects among all team members and have reports/dashboards that will highlight project…
-
Malfunctioning dashboard widget based on Pivot report
Hello, My dashboard widget is showing the grand total column even though this is not a column I have selected on the source pivot report: Grand total showing: Grand total not an option in the "Columns Included" option: This columns header is not selected in the report (sourced by a pivot sheet). Can someone help me…
-
Is there a way to create a 'collapse section' on a Dashboard?
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…
-
How can I chart the last 7 days that contain data?
Hello, I am capturing audit data utilizing the web form for smartsheet, and would like to use a line chart to show average compliance per day, for the last 7 working days. With the holiday weekend that just occurred, I have a 3 day hole in my chart. I have been brainstorming and am trying to come up with a formula that…
-
Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample. thank you!
-
Exporting a dashboard as a PDF
Hello everyone. Recently I built a dashboard and as we want to keep them saved month after month, I tried to export it as a pdf. First of all, I didn't find the option to do so, so I did it via the printing function. It happens that the quality/colors of all my dashboard is very messed up (example attached). Quality used…
-
Question about displaying current month data on dashboards
Hello, We have a sheet tracking monthly metrics and I would like to find a way to flow only current metrics onto a dashboard. My goal is to have the dashboard be a snapshot of the prior month metrics. So if I were viewing the dashboard in June, I'd see metrics for May for several different data points. I'm thinking maybe…
-
Unable to display chart error
I am creating a duplicate dashboard to one previously created. I add the source sheet and it looks fine. When I save it, the source sheet is gone and it says "unable to display chart". Is this a known issue and is there a fix? Update: I found a workaround by switching to classic and adding the source sheets. I could also…
-
Trying to add a sheet via Add Shortcut Widget.
Hello, I am trying to add a Smartsheet to a dashboard via the Shortcut Widget, but when I go to select the sheet it does not appear. The owner of the sheet is shared to my dashboard but I only have editor permission to the sheet I am trying to add. Do I need to be Admin in order to add this sheet via Shortcut Widget?…
-
Allow changes to pie chart formatting when using a grouped report with one category as the source
Currently, when using a report that is grouped by a column, but only one grouping is available, we're unable to change certain formatting options of a pie chart. Specifically, the "Use column names as category labels", "Use first column as series labels", and "Switch rows & columns" toggles. As an example using this…
