Help with creating a smartsheet dashboard!
I created this report showing all of the delayed tasks and tasks for the current week and upcoming week. I want to have a 3 summary charts (most likely a pie chart) with a breakdown by status, a breakdown by workstream, and a breakdown by assigned to.
As the report is right now, I can't create a chart because there are no numbers. So I summarized the chart but when I added the widget into the dashboard the chart had no labels and I couldn't create any.
I tried adding countif formulas to the spreadsheet but I didn't succeed. Also, the count would've counted everything not just the items due this week or next week.
Overall, I need help creating a dashboard that shows just delayed items AND items due this week or next week. I need to summarize the data up top (see breakdowns in the first paragraph) and input the report at the bottom. It would be a massive bonus if I could show the report as a kanban board. So, if there's a way of creating a new spreadsheet based on the report, adding the counts, and then displaying those charts and a kanban board, then you'd forever have my gratitude.