Skip to main content
LukaszMa
Level 3
May 23, 2022
Question

Calculated field help needed

  • May 23, 2022
  • 5 replies
  • 902 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.

5 replies

skyehansen
skyehansen
Level 4
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)

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

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