-
Duplicate Dashboard but with Date Filter
Hi, I am looking for ideas on creating a filter for date ranges in a dashboard. I want users to view the available data in a dashboard by quarter (three months of data). I have a dashboard built that contains all of the data for 2021 that is fed from a single sheet. I intended to continue adding rows to the same sheet for…
-
How to make a sheet that only shows the last x entries of another sheet
Hello, What I am trying to do is track overtime hours taken for each department in our company. I have a sheet set up where our HR rep can submit a form for each week's value, but I need to display this in a chart, and that is where I am running into troubles. For the line graph widget, they would like it to show the last…
-
Dashboard chart from sheet
Hi all, I am trying to create a dashboard chart widget on my RAG status. I have used the symbols in the sheets (Red, Amber, Green, Blue. However, when selecting this data via the widget, I get the following message "the selected columns cannot be charted...." Any advice if I can do this or it just isn't with the…
-
Question on Dashboards
I am trying to create a graph on my dashboard that shows a month by month historical trend line graph. When I try and graph out the info it sorts the months by alphabetical order rather than in the correct order. I have 2 columns on my source sheet pulled into a report one that shows the date an item was entered and I have…
-
Form columns update other form column
Dear reader, We have developed various forms (per service) to map the use of our services by our customers (Non Smartsheet User). The customer must enter his company name on every form, but this is not desirable if a customer submits all different forms at the same time. Is there a possibility to develop one form where the…
-
Jira gadget import to dashboard?
Hello, Is there a way to iframe or embedd an Jira gadget into Smartsheet Dashboard? For example, we'd like to import the sprint velocity gadget into Smartsheet instead of creating it from Smartsheet datasheet.
-
If/Then type formula
I have three percentages that are fed in a sheet summary. I can write this formula in the same sheet summary so there is no reason for cross sheet references. I need to write a formula that calculates the median of the three percentages. The only issue is that some of the percentages based upon the goals are beyond 100%.…
-
Color item no longer representing on dashboard
I have a sheet where a person sets project status. They can choose Green, Yellow, Red, Grey or Blue. Since Smartsheet cannot handle 5 color lights, I do the following. The person can set G, Y, R or Grey directly. If their project is launched (blue), then instead they check a box indicating it it has launched. I have a…
-
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…
