Calculated field help needed | Community
Skip to main content
L
LukaszMa
Level 3
May 23, 2022
Question

Calculated field help needed

  • May 23, 2022
  • 1 reply
  • 899 views

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
May 24, 2022

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)

L
LukaszMaAuthor
Level 3
May 25, 2022

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"))))

L
LukaszMaAuthor
Level 3
May 25, 2022

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")))

Terms & ConditionsAccessibility statement

Loading footer...