-
Dashboard Form Link Icon
This happened once automatically without me doing anything special, but I can't seem to reproduce it. On a project dashboard, when I created a link to a Smartsheet form, Smartsheet recognized it as a form link and gave me a nice icon. Was this feature introduced and then quickly removed, or something? Anybody know how to…
-
Chart Widget = Edit Columns included in the Data Source
Hi everyone. I am using a Project Dashboard template and I need to modify the Chart Widget to reflect the progress of the project by completion %. Unfortunately when I try to edit the column on Edit>Data & Chart type > Columns included I get this message. As a result the widget shows as 100% when in reality only 10% is…
-
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…
