Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??

Hello beautiful community of SmartSheets,

The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that are done.

I need to use the report because the client wants to be able to see who's assigned to each task of different projects (multiple sheets) and I'm not sure if there's a way to have a sheet that brings over that information for example: I want to see all the projects/tasks that Justin is assigned to, so in a report it'll be pretty easy, but in a sheet that self feeds and stays updated as a report would, I'm not sure if it's even possible?

Is there any chances by automation or cross-over formulas?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!