-
How to edit Sheets and Dashboards as Admin
Hi all, I'm an unlicensed admin and my supervisor is a licensed admin. My other supervisor is on leave and is listed as the "Owner" on most sheets and dashboards. Neither of us are able to make any edits to these pages nor can either of us make new dashboards or sheets. I used to be able to make edits with no problem until…
-
Printing Dashboards with embedded Dynamic Views as web content widgets
All, I have a couple of dashboards that have quite a few embedded Dynamic Views in web content widgets. I need a way to print the dashboard (to PDF or otherwise) so that it caputres all of the information in each of the included Dynamic Views. Is there a way to do this? Can Web Content Widgets expand/contract on the…
-
How do I create a scatterplot with the data I want it to have?
All I want to do is set one column as my Y axis, one column as my X axis, and one column as my Labels. How do I do that? Please explain where I can just tell smartsheets where I want the data to go. why does it just throw the data where ever it wants to?
-
Need help creating graph - reports late
I need to create a graph, for two different people, tracking to see if reports are done on time or not. I need to use the assigned to column and then the days late column. Negative were done early, 0 were done on time (Day Of), and then positive numbers will be late. Each graph would be just the one person, and then %…
-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
View "Today" line in Gantt on Dashboard
In a Report, I see a vertical line for "today's date" on the Gantt Chart. However, when the report is dropped onto a Dashboard, the vertical line is not displayed. Any suggestions?
-
Scatter Plot of Age
I have a smartsheet with many (hundreds) of events. On my dashboard, I would like to display a scatter plot of the age (days) of events as of today. I would like to filter the values, so that only events that are currently open display on the dashboard. I already have a column in my smartsheet with the age of each event…
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
Do I need to give permission for everyone so they can view widgets in my dashboard?
I have a dashboard that I want to disseminate out to some volunteers. I just recieved an email from a volunteer that said that he could not see the widgets in the dashboard even though he has access to the dashboard itself. Do i need to go into the reports that are in the widgets and share each one individually with him or…