Forum Discussion
Need help with Microsoft Project Custom formula for auto populating a custome text field
Folks/Guru's, need some help on getting a custom formula driven auto text based on conditions. The logic I am trying to solve here is 1. Align Tasks based on a given month to align a custom field...
Okay, let me know. And if it answers your question, please consider marking my response as the answer.
John
- John, first of all many thanks. I get few errors for few of the rows that have a finish date of 1st of the month as a pattern. Seem to be getting a #error for dates ending 7/1, 8/1, 9/1 for any year for that matter.
- John Sorry hit send too early..it is happening also for dates ending on 31st too..so long story short all finish dates ending on 31st and 1st are erroring out.
Well I did say that I didn't fully check it out. A few tweaks to the formula should fix those issues. Try this formula:
Text1=Switch(month([Finish])>=1 And month([Finish])<4 And day([Finish])>=1 And day([Finish])<32,"R1",month([Finish])>=4 And month([Finish])<7 And day([Finish])>=1 And day([Finish])<32,"R2",month([Finish])>=7 And month([Finish])<10 And day([Finish])>=1 And day([Finish])<32,"R3",month([Finish])>=10,"R4")
John