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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!