-
Realtime Metrics constrained by static columns and dashboard limitations
Smartsheet Community I have a dashboard for client that shows various financial and reporting KPIs/metrics for their business. One of the widgets they have requested is a 12-Month moving sales table that shows current month + last eleven months. I have figured out how to create the table in a sheet using various functions…
-
Has anyone found a good way to visually display daily metrics for the month?
I work in manufacturing and I am trying to build a dashboard for our tiered meetings. I know some people might be familiar with what I am building as it is common in the industry. I have several sheets where Safety incidents and quality incidents etc. can be submitted. My management wants me to build a dashboard that will…
-
Automating Data Mapping in Smartsheet Forms Based on Date Matching
I am using Smartsheets as a daily tracker for my prayers. I am creating a form for this tracker. I have a pre-populated Date Column and then 5 prayers columns with dropdown column options of yes and no. The idea is that every day at a specific time (end of the day) I will fill out the form and update the tracker via this…
-
Task Health Indicator Formula (IF/AND/OR)
Got burnt out looking for my exact scenario in the forums, so looking for direct help. Trying to create a formula to automate my Health column KPIs based on task status and assigned dates. Status options: Not started, In Progress, Blocked, Complete Desired Status Colors Blue: Status = Complete Red: Status <> Complete AND…
-
Multi-Category KPI Tracker - Engage Template Contest Win 2023
Hello Community Forum! I won the template contest last year with my Multi-Category KPI Tracker which I have since updated and added on to. I would be happy to help anyone who has questions or wants to know best practices when using this template set. We use it in our Manufacturing department, but are developing it for the…