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

Calculated Field to Pull in Field on Related Object

  • April 8, 2020
  • 2 replies
  • 482 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

    skyehansen
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe ChampionAccepted solution
    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.

      N
      NickVa7Author
      Level 9
      April 9, 2020

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

      Terms & ConditionsAccessibility statement

      Loading footer...