-
Allow "Timed" messages in dashboards.
There can be extenuating circumstances in which the data behind the dashboard cannot be updated at the time the dashboard stakeholders are expecting. It would be nice to have the ability to add a "temporary" message/banner at the top of the dashboard based on a timer that can be automatically removed (expire) based on the…
-
Publish a Card View to a Dashboard
In the Product Development Template Dashboard, there is a Card View on the Dashboard. I tried to replace that with a Card View for my stuff (the default one had default Smartsheet data in it) but every time I update the web content widget's address with the new one, it goes back to Gantt view. How can I have it default to…
-
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…
