Thanks for the formula…it works great! I have another question now. If I have created a custom enterprise project field that is titled “go live actual date” is there anyway to insert this into the formula? I have tried importing the enterprise field into the schedule I am working on and when I start to edit the formula it does not give me the option to select the enterprise project field. Any suggestions? Thanks!
Jan, yes you can use an enterprise custom field into any formula just like any other field. Just use the same brackets [field] as you would a project custom field. You can also access the enterprise custom field from within the formula by selecting Insert/Field/type(like text) / Enterprise Custom type(like text). Hope that helps…
so is this what the formula should look like? Int((Month([Insert/Field/type(Go Live Actual Date)/Enterprise Custom type(Go Live Actual Date)])-1)/3)+1
My enterprise custom project field is “Go Live Actual Date”
Sorry Jan, I tried to follow the steps for inserting the field into the formula (way too much information). The formula would be:
Int((Month([Go Live Actual Date])-1)/3)+1
Let us know if that doesn’t work. Thanks…