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

Move Row Automated Workflow moving ALL rows regardless of criteria
I set up a workflow to move rows that are marked Closed to a Closed sheet. However, the trigger does not seem to work and when I force run the workflow, it moves all of the rows regardless of what is in the cell. What am I doing wrong?
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?

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