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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!