Best Of

If you just use the email address as the pre-fill value won't it show the display name(s) correctly when matched?

Yes, Smartsheet offers several templates that can help you set up a project collaboration platform with the features you need. Here are a few templates that might be useful:

1. Project Management Office (PMO) Template Set:
   • This template set allows you to track and approve new projects while seeing key metrics across all projects in real time. It includes features for planning, tracking, and reporting on multiple projects.
2. Project Tracking & Rollup Template Set:
   • This set includes pre-built sheets, reports, and dashboards designed to help you manage project tasks, stay on top of deadlines, and access project information through a Project Rollup Dashboard.
3. Project with Gantt & Dependencies Template:
   • This template helps you plan, track, and manage your project with a visual, interactive timeline. You can attach supporting documents and identify the impact of task delays.

To customize these templates for your specific needs:

1. Attach Document Links:
   • Use the attachment feature in Smartsheet to add document links to your rows.
2. Request Review from Stakeholders:
   • Use the Request an Update action in your automation workflow to send review requests to stakeholders. They don't need a Smartsheet license to respond.
3. Send Documents to Multiple Stakeholders:
   • Set up multiple approval workflows. Once the first level of review is completed, capture the approval and trigger the next level of review.
4. Email Notifications:
   • Configure your automation workflows to send email notifications when documents are approved or rejected at any level.

Hi @Andrea Westrich ,

I think this might work for you.

You can add another column to the sheet that has this formula:

=IF(WEEKNUMBER([Due date]@row) = WEEKNUMBER(TODAY()), "This week", "-")

Then on the report you can filter by that column:

Hope it works for you,

Sam