Is there a way to transfer the data from a Task Custom Field to a Project Custom Field using a Calculated Field?

[MariaCr2]

Anyone know of a way to pull data from a Task Custom Field into a Project Custom Field using a Calculated Field? Thanks!

[Sven-iX · Accepted solution]

No. 

Calculated fields don't set the value of other fields. They just show the string-value of the calculation/expression.

You can display the value of a project on the task though with calculated fields: {project}.{DE:someField} in a task form will print out the value of the field someField on the project. 

[Daniel_Clarke]

Hi @MariaCr2 - do you have Fusion? If so that is a fairly easy solve!

1. Watch for data change on task x
2. read task x, output data field and projectID
3. Update project = projectID with output data field

If you do not have Fusion, there are MANY examples like this that increase efficiency and reduce manual efforts that make the value proposition an easy sell to your execs! Message me if you want help crafting that story, happy to assist!

[MariaCr2]

No we don't have Fusion. Would love to have it, and other instances within our company do have it, but we are determined to be too small of a group to spend the money on it at this time. That won't be changing anytime soon, unfortunately.

[Daniel_Clarke]

Understand that for sure! Just sent you a message with a few details on how you could address.