Report on all sheets I am part of as Assigned To

Many of our team members will be allocated to many different sheets.
1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that person.
2. As a second related topic, is there a way toΒ create a report listing the "Assigned to" people in a specific sheet?
Comments
-
Clarification:Β Β Β "Is there a feature how to make a report showing all sheets where I am assigned to a task?"
-
Hi Tommy,
I've answered below in your text.
1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that person.
Clarification:Β Β Β "Is there a feature how to make a report showing all sheetsΒ where IΒ am assigned toΒ a task?"
Yes, there is. If you create a report that looks at assigned to and it includes all workspaces in the where criteria and the who criteria should beΒ setΒ to current user on the assigned to column. Yes to the second partΒ as well.
2. As a second related topic, is there a way toΒ create a report listing the "Assigned to" people in a specific sheet?
Yes, with the same setupο»Ώ as the other question.ο»Ώ
Hope that helps!
Have a fantastic weekend!
Best,
AndrΓ©e StarΓ₯
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andrèe.
I tried but what I want to achieve is a list of all sheets where I have min one task assigned to me. I don't want to see all tasks. Only the sheet names I am involved in/part of.
Same for the second question; I want to create a list of team members per sheet, ideally the sheets in scope listed and one row per assigned to existing in each sheet, then next sheet etc
I am thinking this might require pivot feature or "report on report"Β
Examples:
1. Sheets I have a task assigned to me in:
TommyΒ Sheet AΒ Β
TommyΒ Sheet BΒ Β
TommyΒ Sheet DΒ
etc
2. Team members per project (sheet):
Sheet AΒ Tommy
Sheet AΒ Alex
Sheet AΒ Jim
Sheet AΒ Esther
Sheet B Tommy
Sheet B Esther
Sheet C Alex
etc
Β
-
Happy to help!
I wouldΒ check forΒ that on each sheet or thru cross-formula on another "Metrics" sheet.
Let me know if you want me to clarify, and we can have a quick call about it.
Best,
AndrΓ©e
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Apparently, this feature is available for SmartSheet Gov accounts only... that's sad!