Is there a way to assign a certain task/activity to multiple groups and generate report by group?
I want to use Smartsheet to track progress of task/activity by team or people. However, some tasks/activities may be assigned to multiple teams or people. For example, activity A to be done by x & y. Activity B to be done by y. Then, I want to create a report/dashboard to show all activities assigned to y (activity A & B), maybe in the card view. Is there a way to set up Smartsheet to do this?
I am thinking about some sort of tagging or hashtag function that allows user to assign certain task to multiple groups/people then filter the tasks based on group of person.
Help Article Resources
Check out the Formula Handbook template!