project web app
9 TopicsInconsistent Values from PWA Custom Field Formula
Hello community. Greetings from first time poster. I created the following formula (“FY Project Completion”) to assign a Financial Year value based on Project Finish Date (“Finish”): if the project ends on or before June 30, 2024, Financial year will be FY24, if the project end date falls between Jul 1, 2024 and June 30, 2025, the Financial Year will be FY25, and so on. IIf([Finish] >= CDate(#7/1/2024#) And [Finish] <= CDate(#6/30/2025#), "FY25", IIf([Finish] >= CDate(#7/1/2025#) And [Finish] <= CDate(#6/30/2026#), "FY26", IIf([Finish] >= CDate(#7/1/2026#) And [Finish] <= CDate(#6/30/2027#), "FY27", IIf([Finish] >= CDate(#7/1/2027#) And [Finish] <= CDate(#6/30/2028#), "FY28", "FY24")))) Surprisingly, the formula gives inconsistent FY values, even for projects with same Finish Date: sometimes it is blank, other times it assigns different FY values. I am attaching a representative listing of about 40 projects, 23 of which have wrong FY value. I will very much appreciate it if somebody can please guide me where I need to make change in the formula to get correct values? Dummy Project Name Start Finish FY Project Completion Project in Row 2 11/13/2018 4/30/2021 FY24 Project in Row 3 3/24/2023 3/24/2023 FY25 Project in Row 4 12/14/2020 3/29/2023 Project in Row 5 3/2/2020 7/31/2023 FY24 Project in Row 6 10/25/2023 11/22/2023 FY25 Project in Row 7 1/3/2022 12/31/2023 FY25 Project in Row 8 4/6/2020 2/9/2024 FY24 Project in Row 9 9/7/2023 3/1/2024 FY25 Project in Row 10 1/3/2023 3/29/2024 FY24 Project in Row 11 4/1/2024 4/1/2024 FY24 Project in Row 12 4/1/2024 4/1/2024 FY24 Project in Row 13 4/8/2024 4/8/2024 FY24 Project in Row 14 4/8/2024 4/8/2024 FY24 Project in Row 15 3/29/2024 5/9/2024 FY24 Project in Row 16 5/16/2024 5/16/2024 FY25 Project in Row 17 11/14/2023 5/28/2024 FY24 Project in Row 18 6/11/2024 6/11/2024 FY25 Project in Row 19 7/26/2023 6/28/2024 FY24 Project in Row 20 1/3/2023 6/28/2024 FY25 Project in Row 21 1/2/2024 6/28/2024 FY25 Project in Row 22 1/3/2023 6/28/2024 FY25 Project in Row 23 1/3/2023 6/28/2024 FY24 Project in Row 24 1/3/2023 6/28/2024 FY24 Project in Row 25 1/3/2023 6/28/2024 FY26 Project in Row 26 1/3/2023 6/28/2024 FY24 Project in Row 27 7/27/2023 6/28/2024 FY25 Project in Row 28 1/24/2024 6/28/2024 FY25 Project in Row 29 1/3/2023 6/28/2024 FY24 Project in Row 30 1/3/2023 6/28/2024 FY26 Project in Row 31 1/3/2023 6/28/2024 FY24 Project in Row 56 1/3/2023 6/28/2024 Project in Row 57 1/3/2023 6/28/2024 FY26 Project in Row 58 1/3/2023 6/28/2024 FY26 Project in Row 59 5/24/2023 6/28/2024 FY24 Project in Row 60 1/17/2023 6/28/2024 FY26 Project in Row 61 1/3/2023 6/28/2024 FY26 Project in Row 62 9/1/2022 6/28/2024 FY26 Project in Row 63 1/23/2023 6/28/2024 Project in Row 64 7/3/2023 6/28/2024 Project in Row 65 10/28/2020 6/28/2024 FY25Solved242Views0likes10CommentsNew Project - Regex on Project Name - Limit Special Characters
Greetings, I haven't been able to find any reference to this anywhere online... When creating a new Project in PoL/PWA, is there a way to apply RegEx to the 'Name' (Project Name) field? Basically: I would like to limit it to Alpha-Numeric, Spaces and Dashes...and definitely prevent '&' and brackets '()[]'. Either make it required or prevent 'finish' button (Create project) from functioning until it is valid. What might be a strategy to go about this validation? (Note: I am somewhat surprised this has never been discussed before...especially considering that PWA creates a sub-site & use the 'Name' field as the URL. Frankly, it is surprising that PWA even allows '&'.) Much appreciated, -TRSolved683Views0likes2CommentsProject Web App cross-project links not updating until project is opened
I have setup the Project Web app (PWA) environment and have multiple projects uploaded in the project center. I am using Power Bi as my data visualization tool. I need to set cross-project links for certain tasks, and I am able to set the links but the issue is that when a linked task date changes, the successor (in a different linked project task) doesn't update until I open the project the successor is located. This impacts my Power Bi reports as they don't update until I open the successor project. I've tried creating master projects or simply linking 2 distinct projects (not in master project) is there something I can do (setting, etc.) that would cause the successor task in a different project to update automatically without the need to open the project? Appreciate any input or suggestions.1.1KViews0likes1CommentProject Site - Navigation link broken on Project Detail Page
Hi, We have Project 2019/SharePoint 2019/Project Web App 2019 on premise system. We adjusted Left Navigation menu for project site as shown below. The links were just moved up/down and indented. No changes made to the URL. The above image shows the navigation structure on existing Project site. Project template is created from existing Project Site. When a new project is created, we see broken link (Project Details 1) for Project Details as shown below and new (Project Details 2) is created outside the navigation structure. Project Details 1 link does not go to Project Information page. It exits out to the Project Center The Project Details 2 link goes to the Project information page as expected but it is created outside the section. Please see the screenshot, for site setting -> navigation settings for the project that created using template. How can we fix this issue on the template? Any help on this issue is appreciated. Thank you.1.4KViews0likes3CommentsTime Sheets - PWA - Custom Enterprise column not displaying
Hello, I'm hoping someone can help, I have set up a custom text field with data that I want to use and display in the Time Sheet view of PWA for a selection of users as I need to be able to report on data in this custom field and lookup table for a specific project. Although everything seems to be fine with the created Colum and corresponding look up table, I cannot get the field to display for a selection of users, even though it is present in my Ms Project professional desktop app (as an entreprise field) and in the enterprise data of PWA When in PWA views, I can customise the view and select the custom Colum to be displayed in time sheet data, but it will only show up for a bunch of users and not all users, I'm guessing there is something I need to modify in the User permissions, groups and categories and security temaplates, but amongst the plethora of PWA settings I cannot find the right one to display the said custom field and look up table for all users after quite a lot of searching. Any help or insights would be very much apricated. Best regards, LisaSolved1.3KViews0likes1CommentIE retiring
Hey, We were using IE for the filtering of Projects/ Approvals/ Timesheets for Project Web App. Using other browsers including Edge, the filtering wouldn't get saved. We need to apply filters again. So IE was helpful because the filters used to get saved. With IE retiring now, is there any solution for saving the filters on other browsers? Regards, Amit1.2KViews0likes4Commentsproject team member restrictions
Hi, in Project Web App, I would like to further limit the collaboration privileges of users belonging to a project so that these users cannot change the start and end dates of the activities. The ideal condition would be to be able to change only the activity progress percentage. What are the steps for making these additional restrictions? Thank you.3.1KViews0likes7CommentsSincronizacion de tareas Project Web App
En la organizacion donde trabajo queremos usar el Project Web App para poder tener un mejor seguimiento a los proyectos que manejamos. Creamos un proyecto desde Project Pro, asignamos recursos de la empresa y les asignamos tareas, al momento de publicar el proyecto en PWA, manda correos a cada recurso indicando las tareas que se les fueron asignadas, al momento de dar click en el enlace de Tareas, / In the organization where I work we want to use the Project Web App to be able to have a better follow-up to the projects we manage. We create a project from Project Pro, assign resources from the company and assign tasks to them, at the time of publishing the project in PWA, send emails to each resource indicating the tasks assigned to them, when clicking on the Tasks link , nos manda al apartado de Tareas en PWA y muestra la pantalla en blanco / Send us to the Tasks section in PWA and show the blank screen Si hacemos la consulta de la disponibilidad de los recursos si muestra las actividades como si estuvieran asignadas, pero en realidad no se pueden consultar desde "Tareas" por lo cual no se puede capturar un avance del proyecto. / If we check the availability of resources if it shows the activities as if they were assigned, but in reality they cannot be consulted from "Tasks" so that a project progress cannot be captured.606Views1like0CommentsProject Web App Timesheets Existing Assignments not showing all projects
Hi All, I'm new to the Project Web App but have set up the timesheets according to the MS guides. I'm having an issue on the timesheets where my colleague and I can only see the projects we own in the 'existing assignments' list. We have pooled resources here and we all work across multiple projects, so I need to be able to book time to projects I don't own and have team member be able to book time to my projects. I have assigned everyone as resources to all projects, so I assumed that that would make it possible to book to those projects, but that doesn't seem to be the case - how can I make it so that everyone can see all the projects they are resources for when completing their timesheets?612Views0likes0Comments