I want my dashboard to track a couple of things. First the total number of yes and no's in this sheet (form dumps into it). Then I want it to track the "What info is missing" part and a count for how many for each monthly. I want it to look something like this but with each individual question in "What info is missing" to be its own column if that makes sense. Here is the formula sheet I have for this dashboard… Would this be a good way to do this? I have a lot of questions that will be tracked.

Exactly how are you setting up your filter?

Dashboard Help

How Do I Illustrate Checklist Data in a Dashboard?
I am making a dashboard widget to show how many items in the implemented mitigations column are checked and how many are not. I understand that I may need to make a report or a sheet summary to do so first. How can I make this happen? Also, at some point, I'd like to show a relation to, if it is implemented, is the…
Multiple Approvers on one Approval Automation?
My sheet has multiple approvers who vary by the row depending on certain criteria. I want to send them all the row approval request at the same time, then when they all click approve the project can move forward. To count when the responses are all in, I am moving the entry to a new sheet and counting the references that…
Can I use a condition to remove a user from receiving weekly notifications on an automation?
I have a weekly automation set to send to everyone in my 'owner' column. As each owner completes their assignment, they no longer want the weekly reminder to do their work. How can I remove them and keep the rest?

Help shape the future of Smartsheet.
Share your ideas and feature requests.