Calculated Field to Pull in Field on Related Object | Community
Skip to main content
NickVa7
Level 9
Apr 8, 2020 7:07 PM UTC
Solved

Calculated Field to Pull in Field on Related Object

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.
    skyehansen
    skyehansenAccepted solution
    Level 4
    Apr 8, 2020 8:09 PM UTC

    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.

    View reply

    2 replies

    NickVa7Author
    Level 9
    Apr 9, 2020 8:31 PM UTC

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

    Translate
    skyehansen
    skyehansenAccepted solution
    Level 4
    Apr 8, 2020 8:09 PM UTC

    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.

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...