-
How to embed Outlook calendars into Smartsheet dashboard?
I would like to have a Smartsheet dashboard that includes multiple Outlook calendars. I tried to use the Outlook share link and Smartsheet gives me an error, saying "We couldn't fins any embeddable content from this link." Is it possible to embed Outlook calendars into a Smartsheet dashboard? If so, how?
-
Column categories in chart missing
Dear All, I have the report below and would like to create a easy stacked column chart with the groups as category labels (Product and go to market). What do I need to change? Best, Karin
-
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…