-
Dashboard Widgets - customize view access by widget
would love to have sections that are visible by only certain teams but on a single dashboard😁
-
Seeking advice on template sets.
I am new to Smartsheet and am hoping to get some advice on which template set would be best. My biggest concern is meeting the executive's requests. The executives are looking for a dashboard that shows an overview of the 20-25 projects that we will be running soon. Executives would like the dashboard to include project…
-
Help with Summary report build using matching dates to sum meeting minutes used.
Good morning! I am trying to build a meeting report for my team's weekly Work In Progress (WIP) meeting. I am using a form for team members to fill out how much time they need for our one hour meeting and on which date. I have a formula that takes any matching [WIP Dates] and sums their [Time needed in minutes] The Sum of…
-
What does your favorite dashboard look like?
I am looking for examples and various dashboards to spark creativity on some new dashboards we would like to create. Please screenshot what your dashboard(s) look like and share - blur any private data as needed. Thanks in advance.
-
Calendar view not working on mobile
We had recently added a calendar view of a report to a portal/dashboard we released to our entire company. Reason for the report is we did not want to publish the sheet itself as a calendar to the portal being that when you right click on a date range displayed on the calendar and select "view detail" it would still show…
-
I am looking for creative ideas on how to create a gap analysis
We are currently in the process of assessing our skill proficiency levels, ranging from Level 1 to Level 5. To visualize this, I've created a heat map that illustrates our current skill landscape and the proficiency levels we possess as an organization. As part of our strategic approach, we are now reaching out to external…
-
Moving from 2023 to 2024
In 2023, our data was recorded by regions which then produced a President's report and Dashboard. Beginning in 2024, the data will be recorded as one company and not by regions. My sheets were originally set up with the help of a Smartsheet Professional so I am not sure how the formulas in the background are set up and how…
-
Side-by-Side Stacked Column Bar Chart?
Hi! I have two separate stacked column bar charts - one for 2023 and one for 2024. Both have the same two categories - webinars and onsites - and are comparing them week-over-week. Is there a way to place two stacked columns side-by-side? Here's what it looks like: Here's what I want it to look like:
-
Pie Chart is Grayed out in Dashboard
I have a dashboard that was working correctly with a pie chart widget. Now the pie chart is grayed out and is no longer an option. The data does have values greater than zero so I'm not sure what the issue is. Especially since it used to work just fine. This is the formula I am using in my summary sheet to get a count.…
-
NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE!!!
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 sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple). I log on…