-
How do I convert dates into a time period (month) for reporting?
I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert my rows with PO issued dates between date ranges into a fiscal period/month. Example: I want to convert row cells with any PO…
-
Can I get Unique values on a metric sheet without a complicated work around or report?
I have a column with associate names, over 3,000 rows with over 100 unique names. In order to provide dashboards, I need a dynamic list of unique names listed in that column on a sheet I use to build our KPI metrics. Easy in excel or any other dashboarding tool I use, is this now possible in Smartsheet without using the…
-
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: