Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS PWA question

Status
Not open for further replies.

Aria Consulting

Computer
Apr 14, 2023
1
Hi all,

Hoping someone out there can help with this. I have a client that I'm running a project for. We're using a PWA enterprise project (waterfall). The client really wants the My Assignments view in the Tasks page to have a modified version of the OOTB "Planning Window" grouping with open, assigned tasks for each user accessing that page (and the the My Assignments view pane on the page) to be grouped into 3 groups:

1. Last week's incomplete tasks
2. Current week's open tasks
3. Next week's scheduled tasks
Obviously those groupings need to be dynamic to provide that view on a "rolling" basis the same as the OOTB planning window grouping.

*They're OK if there is a 4th group of "after next week's tasks" type thing to have all the other tasks that don't fall into one of those first 3 groups.
Picture1_pipaef.png


To put it bluntly, I have NO idea how to accomplish this. I had thought maybe creating a couple of custom fields with formulas for "start week number" and "finish week number" to provide a functional data element to to try use for grouping, but 2 problems:

1. If I make the field on the "task" entity my formulas error (#error) but the the fields at least show up in the available fields pick list for that My assignments view, but I can't figure how to create the view to be that dynamic/rolling kind of presentation (this is problem 1 and 1a I suppose)
2. If I make the fields on the "project" entity my formulas work but the the fields then do NOT show up in the available fields pick list for that My assignments view

These are the formulas (assuming this is even a correct part of solutioning this):

Start week no:
IIf(DatePart("y", [Start], 1, 1) > 362 And DatePart("ww", [Start], 1, 2) = 1, Year([Start]) + 1 & " week " & DatePart("ww", [Start], 1, 2), IIf(DatePart("y", [Start], 1, 1) < 4 And DatePart("ww", [Start], 1, 2) > 51, Year([Start]) - 1 & " week " & DatePart("ww", [Start], 1, 2), Year([Start]) & " week " & DatePart("ww", [Start], 1, 2)))

Finish week no:
IIf(DatePart("y", [Finish], 1, 1) > 362 And DatePart("ww", [Finish], 1, 2) = 1, Year([Finish]) + 1 & " week " & DatePart("ww", [Finish], 1, 2), IIf(DatePart("y", [Finish], 1, 1) < 4 And DatePart("ww", [Finish], 1, 2) > 51, Year([Finish]) - 1 & " week " & DatePart("ww", [Finish], 1, 2), Year([Finish]) & " week " & DatePart("ww", [Finish], 1, 2)))

Ideally, it would be GREAT if the same combination of formula fields, view, filtering, grouping (or whatever) could also be used in Project Pro reports to produce an "offline" report. But, if there is a way to get the view to work but not reports, that's an OK compromise.

Simply put, HELP!!!

NOTE: I'm unfortunately NOT a developer so opening up VS Code to do this isn't a viable option.

Thank you!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor