Having to open each source sheet to have the conditional formatting update is not efficient. The refresh on reports and dashboards do not update the conditional formatting for each row. Every single s…
I have a range of $$ amounts (to graph). One of the points is $0.00M; however, the Graph will not "graph" that point, why? is there a way around it? I am using a report to Graph is onto a Dashboard (s…
After adding 20 custom colors in the range of colors for dashboards it is not possible to add more colors, but it is necessary to remove one first, to add or use another one. So far I did not find the…
Reports and Dashboards do not currently update the colors of conditional formatting. For instance, I have it set to change the color when it's 3 days away. Unless I open the source sheet, the reports …
I am trying to capture the sum of duration (hours) for multiple rows. When i generate a row report and select the column and summarize it to sum, the total displays 0. I can get it to count the number…
I have created a workspace for my team where everyone has a sheet to enter projects and I have them all connected to a dashboard using reports and formulas. These sheets are just for small projects, b…
It appears that I can only make a graph of the whole report instead of only one column. Is this possible to do? If not, do I need to make a sheet of the data of every single column of the portfolio? F…
Hello! I am trying to create charts using multiple sheets so I created a report. Although I am not able to figure out how to make it a chart. When I go to chart, it is all grayed out and won't let me …
Hello, I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of s…
How to Add an Interactive Map to Your Smartsheet Dashboard The Challenge One of my Smartsheet consulting clients recently asked how we might be able to accomplish this. They have projects at multiple …
