Looking for help with calculated field on task form

[IsaDi]

I've been asked to set up a custom "Intake Form Due" field which will take a 1-5 value from another custom field “Complexity Level”, then add the date value of another custom field “Original ATV” and subtract that by # of weeks, etc.

For example, there is a field that will ask:

If complexity level = “1”, add the “Original ATV” date -2 weeks.

If complexity level = “2”, add the “Original ATV” date -4 weeks.

If complexity level = “3”, add the “Original ATV” date -8 weeks.

If complexity level = “4”, add the “Original ATV” date -10 weeks.

If complexity level = “5”, add the “Original ATV” date -12 weeks.

Looking for your guidance as I am new in text mode. I did this by creating a calculated custom field on a task custom form using these codes:

IF({DE:Complexity Level}=1,ADDDAYS({DE:Original ATV},-14),IF({DE:Complexity Level}=2,ADDDAYS({DE:Original ATV}-28,IF({DE:Complexity Level}=3,ADDDAYS({DE:Original ATV},-56),IF({DE:Complexity Level}=4,ADDDAYS({DE:Original ATV},-70),IF({DE:Complexity Level}=5,ADDDAYS({DE:Original ATV},-120)))))))

Can anyone help me out with the calculated field?

Thanking you in advance.

[Heather_Kulbacki · Accepted solution]

@IsaDi  I do love a good IF statement!

I think you need a comma before the -28 and a right paren after the -28, and one less right paren at the end and if complexity level 5 is 12 weeks you want -84 instead of -120

If you maximize the custom field calculation area you can lay out your formula like this so it's a little bit easier to spot missing pieces.

IF({DE:Complexity Level}=1,ADDDAYS({DE:Original ATV},-14),

IF({DE:Complexity Level}=2,ADDDAYS({DE:Original ATV},-28),

IF({DE:Complexity Level}=3,ADDDAYS({DE:Original ATV},-56),

IF({DE:Complexity Level}=4,ADDDAYS({DE:Original ATV},-70),

IF({DE:Complexity Level}=5,ADDDAYS({DE:Original ATV},-84)

)))))

[IsaDi]

Thank you Heather! Much appreciated.

Have a nice day!