Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Individual Task List Report (aka "Look Ahead" Report)
We have about 12 projects underway that are using Smartsheet. I'm planning to send each resource on the projects a "look ahead" report that shows all the tasks they are responsible to complete over the next 2 weeks.
I've created the report. consolidating the sheets, but have two questions:
1) It looks like I need to create a separate report for EACH resource. Is there a way to provide a list of names? But it still needs to generate individual reports. If a separate report is needed for each person, it's manageable for now, but as we expand use of Smartsheet to more projects, there will be too many resources for this to work well.
2) Is there a way to include a link to the sheet in the report so they can update the tasks? If I send the list via email, the links that show in the report disappear.