-
Progress % in dashboard
I want to add a widget in my smartsheet that shows how close we are to hitting our target based on a summary total. For example, our target is 200 and the sum total from another sheet shows 100. I want a to show that we are 50% of our goal. Any Idea how I would do this?
-
Web Content Widget rejecting iframe
Using the Web Content Widget, we are trying to embed a video player using a valid iframe tag but received an error saying: "We couldn't find any embeddable content from this link. Please check the link and try again." I tried testing the iframe on a regular web page and everything is working as expected. Are there any…
-
Want to Add Documents from One Drive to Dashboards - Receiving Admin Message
Has anyone else received the following message when trying to connect documents to their dashboard from One Drive? I don't have an issue, but someone else under our license is. She spoke to our Helpdesk and they said it's a Smartsheet issue, but I don't think it is. Just wondering if anyone else has seen this and what you…
-
#DIVIDE BY ZERO
Hi, I have a Smartsheet with calculated columns like - =SUM(Open@row / SUM(Open@row:[Past Due]@row)) The Smartsheet is being used to create Donut graphs on a Project Dashboard. In the example above; Open = 0 In Progress = 0 Closed = 0 Past Due = 0 rather tan getting 0%for Open, I get #DIVIDE BY ZERO How do I resolve this?…
-
Anyone know how this <see imaage> was created for a dashboard?
My team saw this at a partner's site and want me to build them one. I am trying to figure out how this one was built. Or, are they pasting in a image?
-
How do I display a different symbol based on multiple values?
I've searched the community and tried multiple formulas but I cannot seem to get this scenario to work. I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display. Scenario: 0% = Green 1% - 10% = Yellow 11% and over = Red This is the formula I'm currently using. I get the Green…
-
Standardizing Scale on Y Axis
Is there a way to standardize the scale on the Y axis of chart widgets in the dashboard? I want to standardize to 100% on all graphs, but the dash auto-selects for me. If this isn't available yet, could it be added to the options? Visually it would really help the people for whom this dash is developed. Right now %…
-
I would like a chart in a dashboard show the sum value in the summary line of a report
Hi everyone. I have reached the max on a sheet leaving me to archive it and creating a new one. Once I have done this, I want both sheets on my report and from there sum the values and then portray that value in a chart on a dashboard. Currently the dashboard shows the chart from each sheet, not the sum of both sheets. How…
-
Status Report / Table
Hello, I am stuck with piecing together what I thought would be a simple visualisation. I'm trying to build a report to go into a dashboard that shows the status of various projects in a table like this: I need the columns across the top to run left to right in a specific order and beneath that I want my Project Names to…
-
USING FORMS WITH pARENT /CHILD ASSOCIATIONS IN SPREADSHEET
Greetings, Below is a screenshot of a spreadsheet that has parent / child associations. I would like to create a form that will allow team members to input the various meetings & Times, they have during the week. 1-can smartsheet automatically put the response in child rows when a parent row( week Day) has been selected?…
