Multiple Checkbox's for sheet summary into a dashboard.
Good afternoon, I am looking to see if this is possible. I am looking to have a dashboard automatically populate with a new row when another is "complete". Which I am able to accomplish with automation tasks. The issue is building the dashboard that has multiple columns of checkbox's. Please see the photos below for an example.
So this is how my sheet is utilizing checkbox's looks currently.
I have been tasked with creating a dashboard that once the checkbox is checked for "Complete" it moves to a archived sheet. Which is working as intended.
What is not, is the dashboard that they are wanting for this sheet. See below.
So this is a section of the dashboard. Currently we have been using the metric widget and referencing the cells. But as you can imagine when they move from the sheet they were referencing it shows "Missing Data". Now for all of the other non-checkbox fields that were causing this issue, we have been using the "Sheet Summery" fields and indexing them. this way when one falls off the next row populates accordingly.
Finally on to my issue, I have been unable to find a combined formula that will simply show all of the checkbox columns in a group like it shows above. Or simply a Yes or No in reference to there respective column. I was hoping that if this is possible if anyone could enlighten me.
Obviously, I know this post may be a bit convoluted. So if more detail is needed please feel free to ask.
Help Article Resources
Check out the Formula Handbook template!