How do I change the columns on a task rollup report?
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does. Instead, it imports every task in the base file and it's respective status as rows. I want to instead just have 1 row and the sum of tasks by status in the columns. How do I do this? I'm also unclear on why the template's report has a different Report Builder interface than the version I'm trying to build with my own smartsheet. Why does the template report show each status value as a column to display, but mine only gives the option of displaying what the status is?