-
IFRAME - load with Fullscreen option
I'm embedding several reports / dashboards into a sharepoint instance and I would like to have them load in full screen by default. I am referring to the Normal View Vs the Full Screen View that can be achived by clicking the appropriate icon on the bottom left of the embedded frame. Please help! Thanks
-
Add up all PAST DUE Items
I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this? Thank you from the newbie!
-
COUNTIF or COUNTIFS
I think I have formulated myself into a corner. What I am attempting to do is create a total number of all open projects based on the multiple status options in 5 separate columns. So, if the data in columns Stats1:Stats5 match X or Y or X, return that total count. I am able to do this for One…
-
Dashboard reports
Does anybody know how to autosize reports is dashboards, for example if I have 4 rows to show all 4 rows without having to resize the dashboard or if I have 10 rows to show all 10 rows?
-
Dashboards (sights)
Hi All, I'm wondering if anyone can help me out. My current client has one program where each staff (4 in total) each individually have their own projects. I created a sheet for them to use that has these columns: Task Name. Start. Finish. % Complete. Status. Assigned To. Done. Risks. Risks & Issues. The staff go into…
-
Report Enhancement Request
I would like to be able to reference filter criteria for reports from a single top level cell. My project and workaround/issue is below: I am in the manufacturing business. We have machining lines that have a number of operations: ill say on average its ~20 operations. Each operation has an operator that at the end of the…
-
Multiple Countifs and Children to use in a Dashboard
Hello Everyone! I'm new to figuring out counts in SmartSheets and Dashboads/Sights and could use a little help. I have a sheet that is connected to Salesforce via the Salesforce Connector, so the data is dynamic. I currently have the sheet grouped by department. Under each department are children rows for projects. There…
-
Summary Cells & Adding Rows
If I understand Smartsheets correctly, all formulas must reside within the sheet where the data exists meaning, if I want to display a metric or a total on a Sights Dashboard or Report respectively, I cannot. So, what do you recommend I do to create summary cells on a sheet where rows will be continuously added?
-
Chart Related Queries
Today's Rabbit Hole: Charts. Here's some things I did not know or thoughts I had today: 1. When building a Chart in a Dashboard, can I somehow import an existing Chart built using Smartsheet Labs? (From Reports, Labs allows 100 rows of data, Dashboard widget allows 500 rows of data) 2. In Labs, is it possible to switch…
-
Mobile app doesn't show dashboard graphs
I can't view any of the graph widgets on the mobile app. Is this a known issue or are my settings wrong?
