Expand my Community achievements bar.

# Workfront

SOLVED

## Looking for help with calculated field on task form

Level 2

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:

Can anyone help me out with the calculated field?

1 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.

)))))
2 Replies

@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.