## Forum Discussion

I don't really understand your second question as to how it relates to the first question. They seem unrelated. But I will take the liberty of simplifying your current formula because it's written in an Excel type manner which is needlessly complicated with parentheses

IF(

[Request] = "Add New Resource" and [New Employee Type] = "FTE",

[PRM Level - New FTE Monthly Estimate] * [First Year Duration],

[Request] = "Add New Resource" and [New Employee Type] = "Contractor",

[Contractor Monthly Estimate] * [First Year Duration],

[Request] = "Include Existing Contractor - No Conversion",

[Contractor Monthly Estimate] * [First Year Duration],

[Request] = "Include Existing FTE - Continue or Shift Project",

[FTE PID - Level Estimate - Monthly Estimate] * [First Year Duration],

[Request] = "Add New Contractor + Add New FTE for Conversion",

[Contractor Monthly Estimate] * [First Year Duration],

[Request] = "Include Existing Contractor + Add NEW FTE for Conversion",

[Contractor Monthly Estimate] * [First Year Duration],

[Request] = "New FTE (Related to Conversion)",

[PRM Level - New FTE Monthly Estimate] * [First Year Duration])

as for the first question.

The formula for [Year 1] would be

Year([BUSINESS CASE START DATE])

Then the formula for [Year 2] would be [Year 1] + 1.

etc for the rest of Years 3, 4 and 5.

- ReneeHansen12 months agoQrew Cadet
Hi Mark! LOL thank you for deciphering my formula! I will fix it! :)

Also - Yes, wow that seems so easy for the Year. I'm sure I'll have follow up questions. - ReneeHansen12 months agoQrew Cadet
Ok, I do have a follow up question.

I also have duration formulas (year 1 duration, year 2 duration, year 3 duration, year 4 duration, year 5 duration). I'm not sure where the formula for the Year would go -Year([BUSINESS CASE START DATE])

Then the formula for [Year 2] would be [Year 1] + 1.

does it go into the duration formula? Or does it go into the Year $ formula?- MarkShnier__You2 months agoQrew Legend
[Year] will be a formula NUMERIC field type, not duration.

Then the formula for [Year 2] would be [Year 1] + 1

- ReneeHansen12 months agoQrew Cadet
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.