I am trying to display a chart on a dashboard that displays Complete vs incomplete items using a single column on one sheet as a source. Should I create a report, then generate a metric widget? What is the best way to do this?
What i do is make another "Utility" sheet and use a COUNTIF()/ COUNTIFS() formula.
IE
Completed Items
=COUNTIF({Sheet Range 1}, "Completed")
Incomplete Items
=COUNTIF({Sheet Range 1}, "Incomplete")
After that use the Metric widget and display those items. It will auto update after you make changes in your sheet which is nice.
If you want more criteria use COUNTIFS() Like Completed items that are in "X" Department or whatever.
Michael
Thanks Michael!
I have multiple task checklists to monitor so I need one weekly report that will show all the past due tasks from every checklist under the one Workspace. Currently, I'm adding the Automation to each checklist. Is it possible to just add it to the Workspace itself and run to capture from all the checklists?
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan
I need to add clickable links on a Smartsheet Dashboard that automatically update based on changes made in a Metric Sheet. I tried using a Metric widget, but the links appear only as plain text and are not clickable. Is there a way to have hyperlinks on the Dashboard that stay clickable and get updated whenever the Metric…
