Calculated Field to Pull in Field on Related Object | Community
Skip to main content
N
NickVa7
New Participant
April 8, 2020
Solved

Calculated Field to Pull in Field on Related Object

  • April 8, 2020
  • 2 replies
  • 481 views

Hi WF Community,

I'm looking to pull in the Planned Completion Date to a custom calculated field on an Issue form.

I've attached a screenshot of my formula. Can anyone advise as to what I'm doing wrong?

Thanks.

Nick

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

    You might want to use "Source Task.Planned Completion Date". I usually find the fields by creating a report and seeing what I would use in that report space. So by pulling up an issue report and looking through the fields, I don't see a Task section but I do see a Source Task section. So that would be my first guess about what would work with the issue calculated field. By the way, I see your calculated field is set to text... you might want to set it to Date or Date/Time instead.

    2 replies

    N
    NickVa7Author
    New Participant
    April 9, 2020

    That worked...thanks, Skye....and for your thought process.

    skyehansen
    skyehansenAccepted solution
    New Participant
    April 8, 2020

    You might want to use "Source Task.Planned Completion Date". I usually find the fields by creating a report and seeing what I would use in that report space. So by pulling up an issue report and looking through the fields, I don't see a Task section but I do see a Source Task section. So that would be my first guess about what would work with the issue calculated field. By the way, I see your calculated field is set to text... you might want to set it to Date or Date/Time instead.

      Terms & ConditionsAccessibility statement

      Loading footer...