Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Calculated Field to Pull in Field on Related Object

Avatar

Level 10

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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 solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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.

Avatar

Level 10

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