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...
Try this formula in a custom task Text field.
Text1=Switch(month([Finish])>=1 And month([Finish])<4 And day([Finish])>=1 And day([Finish])<31,"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])<31,"R3",month([Finish])>=10,"R4")
I didn't check it out 100% but here is the result on a quick sample file
John
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.