-
Day counts
Hello, I am working on formulas to gather our end date/past end dates for example I want to capture 45-day, 30-day, 15-day, 10-day and 5-day I do not care if it is in a pie or metrics just not sure the best way to gather the data with there already being a formula in the column to calculate those days then present them on…
-
My chart made from a report will not show the date information on the horizontal axis.
When I make a chart from a report the date does not show up. If I make it from a grid sheet the date is there. Using a sheet means I have to update it manually each day. How can I get the date to show up on a chart using information from a report?
-
Dashboard chart from Pivot breaks each time it is refreshed
I have a series of dashboard charts that are created directly from a sheet created and updated by the Pivot app and, each time the sheet gets updated based on the schedule defined in Pivot, the dashboard charts break and present the message "Unable to Display Chart." I have seen other post that contained this message for…
-
Week Ending Date on Dashboard - Automatic Update
Hello, how can I leverage the metric widget in a project Dashboard to display 'Week Ending X/XX/XXXX' that updates automatically? For example, for the week of 11/8/21-11/12/21, I would want the widget to show Week Ending of last week (11/5). When it becomes 11/15/21, I would want it to display 'Week Ending 11/12/21'. Do I…
-
Dashboard Chart Data Selection
When I add a chart to a dashboard, it prompts me to select a sheet, but not the columns to display in the chart. If I try to select data fields of categorical labels and data that are not next to each other, I get an error. How do I select the data to display and can it be summarized? For example, I have a sheet tracking…
-
Search on Dashboard
Any suggestions on the following without using Dynamic View: Dashboard has a report Search Box where a user enters data that return the list from the report directly into the Dashboard thoughts?
-
Google Sheet Embedded in Dashboard Not Editable
Hi folks, I was able to embed a google sheet into a smartsheet dashboard using the web content widget. I allowed the third party cookies and am now able to see the sheet that is embedded. The problem is that I cannot edit it! Is there something I am missing? I have tried in both firefox and chrome. Thanks, Leah
-
Embed a URL with a specific port in Dashboards
Hi All, We have web applications running on non standard ports (i.e. https://www.[whatever].com:[1234]/) but looks like when a custom port is specified in the URL it is not recognised and cannot be embedded. Of course it works if you don't specify the port (but then you don't get to the right service..) Is there a way to…
-
How to display multiple dashbards on monitor or Display device as a slide show
Hi We have build a number of dahsboards of differnt natures (sales, finance, safety etc) and wish to display these dashboards on some display devices (large monitor etc). What will be the best way to do that? I can dispaky single dashboard but not multiple in a slide show way. Anurag
-
Dashboard Chart
Hi, Anyone saw this error before when trying to add more than 4 columns and 5 rows? "Selected data cannot be charted" Thank you!