-
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?
-
Power Bi dashboards?
Hi Community i'd be interested to know how useful members are finding the Smartsheet linkage with Power BI to create some excellent Graphical dashbards possibly as a supplement to the more Numerical View achieved in Sights? Could any of you describe your Use case? Could you describe how easy or Difficult it was to set up?…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
