Is there a way to format groups in a report?

whatasave91

I have created a report that pulls every task with my name on it, and they're grouped by sheet name. Is it possible to change the group header where I can add notes, change cell color etc?

If not, is there a way I can create a new sheet that pulls the same tasks?

Andrée Starå

Hi @whatasave91

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

For the second question, you could export it to an Excel sheet and then import it again to a separate sheet or add a so-called helper sheet that could show what you show in the report.

Make sense?

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

whatasave91

https://community.smartsheet.com/discussion/comment/404221#Comment_404221

Thank you for the response! I'm not sure exporting would do what I need, as my report pulls from dozens of sheets across different workspaces and updates itself as new sheets are added to them. If there is a way to set up a sheet that can pull the same data that the report does in real time, that would be perfect.