charlies_stuck
New Member
- Joined
- Oct 4, 2022
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi Guys - I would like to dynamically update the Sprint Field (or maybe create some custom fields : "My Sprint" and/or "My Sprint Week" as a Sprint is based on 5 weeks) which will be updated if the date changes.
To add some context:
I have the Sprints set up:
And then depending on the start date of a task, have the field related to the task update as required.
If we cannot create a formula and use the Sprint Table above, I guess we can write a long IF/THEN formula. I wont attempt to suggest an logic but the functionality is
look at the task start date and then fill with the appropriate Sprint Week.
I do have it in Excel (thanks to one of the community) but that means exporting out of MSP and messing around with the Date Formatting and then reloading/copying back to MSP. The reformatting of of the Date field is a night mare so I was wondering if we could do it via the MSP formulas.
Thanks in advance for your help
Charlie
To add some context:
I have the Sprints set up:
And then depending on the start date of a task, have the field related to the task update as required.
If we cannot create a formula and use the Sprint Table above, I guess we can write a long IF/THEN formula. I wont attempt to suggest an logic but the functionality is
look at the task start date and then fill with the appropriate Sprint Week.
I do have it in Excel (thanks to one of the community) but that means exporting out of MSP and messing around with the Date Formatting and then reloading/copying back to MSP. The reformatting of of the Date field is a night mare so I was wondering if we could do it via the MSP formulas.
Thanks in advance for your help
Charlie