-
Customer Facing Dashboard
Hello We are starting to use Smartsheet on customer facing software implementation and want to leverage the use of dashboards as a customer 'hub'. Does anyone have any examples of customer facing dashboards that you use specifically for software implementation that you would be willing to share (feel free to block out…
-
Resizing Sight To Eliminate Blank Space
Hello, I'm having an issue with a sight where there is blank space at the bottom of the sight which will not go away. This looks ok when using the sight in smartsheet, but when it's embedded in another application using an iframe, it leaves some space. That means the height of the frame has to be large enough to span the…
-
Looking for an automated way to Pareto Dashboard data in a Chart Widget from a Report
I have large datasets with various records that have spikes and some that have only a few occurrences. Right now I have things structured in a main sheet where all the data is entered, then a summary sheet with the potential values (which need to be manually maintained to some degree) with a VLOOKUP formula to count the…
-
SUMIFS I think?
I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is: =SUMIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >=…
-
Pulling data from one sheet to another
I am currently in the process of creating a dashboard. I was originally planning to use cellular formulas to pull this data. The original formula I was using is: =COUNTIFS({JBO Type}, "Overhead", {Date}, IFERROR(MONTH(@cell), "") = 11) However, this formula is returning an improper total, it reads "24" when it should be…
-
Attaching a file to a sights widget
I have attempted to link a file (from onedrive) to a widget in sights and have also attempted to upload from googledocs. When the user clicks on the link or file, the system takes them onedrive saying access denied or to googledocs online. How do i attach a word doc so it is not connected to onedrive or googledocs?
-
Summarize drop down selections in a dashboard chart
Hi all - I created a workflow process for a guest recovery project. With each line item, I have identified drop down selections for users to summarize guest issues. Some records may have one item selected, others may have 5 items selected. I've not found a way to create the chart using one specific column of data. The…
-
Dashboard Chart Widget Axis changes with each refresh
The axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. I have a Support ticket in, but no good response. This is happening on multiple…
-
Format axis on chart on dashboard
I have a stacked bar chart that is budget consumed/remaining. I do not want to show any decimal places on the x-axis labels. I have changed the number of decimals in the sheet from which I'm pulling the data, I've even made it No Currency but only the $ disappeared, not the .00s. How do I make those go away? Thanks in…
-
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…
