office 365
101 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 FY25Solved88Views0likes8CommentsYou don't have permission to access items on this site
Hi All, One of my users is facing an issue with the Roadmaps feature in Microsoft Project. The user is assigned a Project Plan 3 license. I have the following settings enabled. However, when the user tries to use this feature, they encounter the following error: ": https://contoso.sharepoint.com/sites/pwa. Change your default PWA site or request permission to this site." I am not familiar with this site. When I checked the SharePoint active sites, I found this site with the following details: Site Name: Project Web App Site Address: https://contoso.sharepoint.com/sites/pwa Do I need to provide access to this site for the user to use the Roadmaps feature? Please guide me.40Views0likes1CommentHow to enable Auto Save on Project 2016?
Hello everyone! When I posed this question to all encompassing search engines (including MS) I get a flurry of articles telling me to go into save options and enable autosave so it saves every 5 minutes, etc. That's not the autosave I'm looking for. All my other office apps have a toggle button on the title bar "Autosave ON or Off" which works in conjunction with Microsoft OneDrive to automatically save your file while working, as well as provide the ability to have your office files on your local system and automatically backed up to the cloud. I can't find any articles about how to enable this. Please advise what I am missing.Solved7.8KViews0likes5CommentsProject Online Task notes update using Rest Api
Hello, I am able to create a new task and then I can give the value for notes field which works fine but when I try to update the same "Notes " field then the update doesnt happen using the rest api I am using below rest api with Patch method _api/ProjectServer/Projects(<project_id>)/Draft/Tasks(<Task_id>) Body: {'Notes': value}2.5KViews0likes2CommentsProject for the web - view only user
Hi, is it possibile on project for the web assign role to each users in the plan? Some users should not modify data but just look at them! Actually everyone can add task, modify dates etc.. that's a huge issue! Only PM should do that ThanksSolved181Views0likes1CommentMS Project - Different links between operations in print and processing view
Dear Community, I have a problem with the links of my processes. In order to be able to compare the former dates (target dates) with the actual dates (actual) or the postponed dates, I have carried out a target/actual comparison via the GANTT diagram monitoring view. However, something does not seem to work with the display of the link lines between the tasks. The following problem description: In my Gantt chart view (image 1), the links are displayed correctly by the system, just as I would like them to be. The actual dates (on the right-hand side) are linked with connecting lines. However, if I then want to print the plan, the links refer to the target dates (on the left) of the activities and no longer to the postponed or actual dates (on the right). I would also like to have the views from image 1 as a print view so that I can send it to the customer as a PDF. What could be the problem? My thoughts go in the direction of the different stored dates (Fig. 3) or bar types (see Fig. 4). However, I have tried everything and have not found a solution to the problem. Can anyone help me? Figure 1: Figure 2: Figure 3: Figure 4:119Views0likes0CommentsMicrosoft Project for the web API
Hello community, I need to work with MS Project for web over api, CRUD projects, CRUD tasks and etc fromhttps://project.microsoft.com/ with using an API. I searched and couldn't find any documentation or SDK to do it. Only one page from offecial source about API here https://learn.microsoft.com/en-us/project-for-the-web/projectforweb-admin-home that point to https://devblogs.microsoft.com/microsoft365dev/tag/project/ The both links without any API description for Project for the web. Is there any documentation for an API to integrate with Project for the web? Thank youSolved1.6KViews0likes1CommentProject for the Web / New Planner
We currently use Project for the Web. I have been told that it will become obsolete and be replaced by the NEW Planner - is this correct? If so, is it simple to transition over? What do we need to do, to ensure that we have a continuous project management tool? Is there a 'hard' end date for Project for the web?1.7KViews0likes3CommentsAccessing Project Custom Fields in Power Automate
Hi I have created some custom fields in my project and I'm trying to create a link to a SharePoint list using Power Automate. I am able to access the out of the box fields in the flow via the Dataverse connector, but there is no sign of the new custom fields I created. Does anyone know exactly where these new custom fields are created? - and if so am I able to access them from within Power Automate? Thank you in advanceSolved3.3KViews0likes5CommentsEnhanced collaboration in Project for the Web with your Microsoft 365 license
We’re excited to share that as of today, you can edit shared projects in Project for the Web using a Microsoft 365 license. This frequently requested feature enables you to collaborate more seamlessly with your colleagues on projects.8.3KViews2likes24Comments