-
Issues with creating a Bar Graph on a Dashboard - Unable to select appropriate data
Hey everyone, I've got a question regarding a Smartsheet Dashboard. I have created the outline of my dashboard, and begun to pull some of the figures into it. When trying to pull the two columns I need to create a bar chart (overall employee satisfaction by department) I am unable to actually choose the two columns I need…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…
-
Summarize tasks for assigned teammate on an intake tracker
Hi there - I am not understanding how to use this COUNTIFS formula above. I am in the process of creating a SmartSheet dashboard for my team from an intake tracker we have. I would like to use the metrics widgets which require sheet summary formulas. Problem - I am trying to create a sheet summary of how many current tasks…
-
Chart Widget -- Legend/Series behavior linking out to other Smartsheet Items
Today, we can have a behavior/action at the widget level only. I would like to attach a Smartsheet Report to each of the Chart Legend/Series. So, while I select the color and size of each Legend Series, I would like to attach a Report. At the moment, I have a workaround by using "No Legend" in the Chart Widget, then…
-
Nesting If Statements and Dates
Hi, I am trying to create a status column that will populate a field with the parameters below: "Yes" if all of the cells in the row have "Yes" selected. "Late" if the today's date is greater than the due date and all of the cells in the row don't have "Yes" selected. Or else "No". I have tried several different formulas.…
-
Is it possible to embed custom HTML or JavaScript in the smartsheet dashboard?
Hello, I am trying to embed an interactive dropdown menu created using HTML in the smartsheet dashboard using the Web Content widget. It was embedded but it showed up as an error. I want to know if anyone tried to embed HTML or even JavaScript into the dashboard. If it is possible please let me know. Thank you!
-
Dashboard. Rich Text Widget. How to remove hyperlinks?
I have a text (paragraph) which is linked to another sheet. Is there a way to remove the link without deleting the entire text?
-
Dashboard/Report not updating
We have a team dashboard that is not showing correct data. It seems that the underlying report is not updating. What is wrong?
-
countif and contains statement for extended drop down menu
Hi all, I would like to reach out to the community to help me solve my (probably simple) issue I am facing. To provide you with some context: I am building an online database to enable tracking all the requested amendments and to gain inside into invoicing on a small scale. This database is created for different layers to…
-
Embed Dashboard Widgets into Documents
It would be great to be able to embed dashboard widgets into documents in the document builder, allowing for the creation of fully formatted project reports to key stakeholders.
