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…
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…
would love to have sections that are visible by only certain teams but on a single dashboard😁
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…
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…
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.
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…
Hello community! I am new to Smartsheet and I am trying to work on a my Hospitals volunteer databases to bringing the 3~4 different programs that we have running into Smartsheet. We have one for each of the following; volunteer onboarding/application tracking, annual learning, volunteer time and location tracking, and…
Hi there - Is there a way to show the total values for data in a stacked bar chart?
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…