I'm working on creating a house maintenance spreadsheet and want to create a notification popup or sparkline that is visual that shows me the the completion level of the tasks. Is there a way to make this happen? I can create individual sparklines for each task, but I wanted a sparkline or notification that covers a room, so the kitchen has multiple items. I can make the sparkline for the indiv items, but not for the kitchen, so when the "kitchen" header turns red, then I know something within the collapsible group needs to be tended to.
I've been able to get the basic sparkline to work but nothing beyond that.