Reports - activity due date "smoothing"

Bernita Smith

 I have multiple projects with multiple activities within each project (activities are identical but have different start dates). Example below. So if I have 100 projects and Stephan Voges is responsible for GL quotation, apply corrections etc. (as below) for each of the projects I would like to draw a report for him so he can look at all his activities across all projects assigned to him and stagger the dates so he can cope with the workload. Can anyone show me how to do this, please?

Andrée Starå

Hi @Bernita Smith

I hope you're well and safe!

You could use the Current User feature, so you only need to create one report, and it will show tasks for the person viewing it, and then you could use the sort or grouping feature to show it as needed.

Did that 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!

Andrée Starå

@Bernita Smith

More info.

https://help.smartsheet.com/articles/2482087-view-your-assigned-tasks

https://help.smartsheet.com/articles/2480331-control-what-people-see-report-chart-widget