-
Comments in Sights
Is there a way to pull comments into a sight? I am new at this and trying to create a dashboard and was hoping to use the comments field and pull it into the dashboard. I have tried to do it straight from the metrics widget but it won't let me select any comments. I have also tried to create a report but it doesn't…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Printing a Sight
Sights look to be a great addition to smartsheet. I am currently in a 10-day trial but I dont see an option for printing the sight. My thought is that it would make a good cover sheet to our status reports going forward. Is this currently an option that Im missing?
-
Updating Dashboard
So I have created a Dashboard with Metrics and Graphs only to learn that as the underlying data in the sheet is updated the widgets do not update they are static. Given the number of dashboards to be built it is not feasible to manually re-point the widgets to the latest data. So I need a workaround. Given that the widgets…
-
New Graph functionality
Hi, We have been pining after graph functionality for a while in smartsheet and thought the latest release may have addressed this. Could anyone suggest a way to address the following (please see attached picture) We would like to add a target line to a bar graph to visually see where employees are over allocated.…
-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Editing Labels on Charts
Is it just me or are we not able to edit the chart labels anymore? They just brought out a bunch of a new charts and I can't seem to format word/number like I used to.
-
Charts and Sights
Is there a way to get a Smartsheet Chart in a Sight?
-
Chart Columns
Notice in the attached picture that I have a chart that shows how much reimbursement a specific client received last year and as of the current date the client has received almost half of that. The issue is that the FY1718 (Red) column appears too small for the actual result. Visually, shouldn't it be about half the height…
-
Countif and countifs not updating
I have created a smartsheet with a number of different formulas in to pull together monthly figures. I then use this information to populate charts in my sights. One view I use is to count the number of new jobs added each month. This was working great until latest update. When I look at my sight the chart is no longer…
