-
Report on "Current User" on a Sight
When we show a report that is built with the new "Current User" contact functionality, that works great! When we show that report on a Sight, it doesn't dynamically follow whoever is viewing that Sight. The report only shows the tasks assigned to the author of the Sight. That doesn't seem right to me. Does anyone else have…
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
-
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?
