What method can Pierre use to send his project teams a weekly email with their tasks?

The best method for Pierre to send his project teams a weekly email with their tasks is to create a task list report and schedule it to send as an attachment weekly. This approach is efficient and allows for automation, ensuring that team members receive the most up-to-date information about their tasks without needing manual input each week.

By creating a task list report, Pierre can compile relevant tasks from various sheets and present them in a clear format. Scheduling it to send as an attachment means that the team members can receive this report without needing to log into Smartsheet, making it convenient for them to view their assigned tasks directly from their email.

This method streamlines communication, minimizes the risk of oversight, and ensures that all teams have consistent access to their tasks. It also allows Pierre to maintain a standard format for the reports, which can improve clarity and usability for the team members.