Derive the Year from another field
Hi, What I want to do: I want the "Year" fields to derive which year it is based on the Business Case Start Date. but I don't want the year to be static. The fields I feel are important: [YE...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend[Year] will be a formula NUMERIC field type, not duration.
Then the formula for [Year 2] would be [Year 1] + 1
ok, but I think I'm confused because I have all of my formulas built, and I need to slide this one in somewhere - so I'm just not sure where I need to put it to use it effectively.