Calculated field help needed | Community
Skip to main content
LukaszMa
Level 3
May 23, 2022 7:21 AM UTC
Question

Calculated field help needed

Dear All,

I want to to set up a calculated field in a custom form Im working on. I tired several different statements but Im far from syntax expert. I spent too many nights trying to solve these sort of puzzles on my own :) Can anyone help?

I have following custom fields:

A - dropdown with values: Yes / No

B - single line / number

C - single line / number

D - single line / number

E - single line / number

What I want to achieve is a calculated field to display a sum of B+C if A=yes or D+E if A=No.

Thanks in advance and have a great week ahead!

Kind regards,

Lukasz

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

5 replies

skyehansen
skyehansen
Level 4
May 24, 2022 12:11 AM UTC

can you show us what you have come up with that isn't working? I'll assume you've already checked out the help article on this (https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus)

Translate
LukaszMaAuthor
Level 3
May 25, 2022 7:25 AM UTC

Hello Skye

Yes, I tried variations of what I was able to built in gsheet but I don't fully understand how to transpose it to WF syntax

=IF(A="Yes",SUM(B,C),IF(A="No",SUM(D,E)IF(A="","Not Required"))))

Translate
LukaszMaAuthor
Level 3
May 25, 2022 8:48 AM UTC

I think I finally managed to break this down :)

IF(A="Y",SUM(B,C),IF(A="N",SUM(D,E),IF(A="","Not Required")))

Translate
Terms & ConditionsAccessibility statement

Loading footer...