-
Upcoming Birthday Report
I would like to include a Report Widget that shows upcoming birthdays, but it doesn't seem possible to only pull data according to month and date (whenever I use the date column, it automatically adds the year -- 2018, in this case). Is there anyway that I can pull data for upcoming birthdays w/o relying on the year they…
-
Dynamically update dashboard after form submission
I am experimenting with the Sights feature, and attempting to have my dashboard update whenever a new web form is submitted. We have some metrics that are manually updated every week, and I'm hoping to auto-populate an overall view. However, a new form submission doesn't update any of the numbers in my Sight, they are…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
PivotTable
Hi all, How can I create a PivotTable on smartsheet? for create like this graph in attachment
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
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.…
