Dashboard- weekly project status submissions

Hi,

I would like to create a monthly dashboard that displays which project managers have submitted their status each week. I have a master Project Management Sheet where project managers submit their status. I plan to have an automation that clears whatever the project manager has added , in order to make room for their new status the following week. My question is, how would I be able to track their weekly submissions and report on them, if they are cleared every week? I would sincerely appreciate any advice, tips or tricks.

Thank you!

Find more posts tagged with

Reports

Dashboards

Accepted answers

All comments

Gia Thinh

Hi @andhou,

There's no need to clear submissions in your master sheet. Just leave them there for tracking weekly.

You can add some helper columns : "Year", Week", "Current week" to get information from the "Created" column by below formulas:

=YEAR(Created@row)

=WEEKNUMBER(Created@row)

=IF(Week@row = WEEKNUMBER(TODAY()), 1)

Then create a report with filter of "Current week" is checked, and show the report in the dashboard.

Hope that helps.

andhou

Hi Gia,

Thank you for your detailed answer. I appreciate i!

jasminao624

Hello Gia -

I am interested in this as well. I've added the helper columns and created a new report - however, my PM's updates are flowing into the same row (see attachment). Is there any way to pull and report only on the latest 'updated text'?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.