Ways to use Calculated Fields across Apps

I have a couple of Apps - Projects, Issues and Timesheets - where an Issue has a single Relationship to Projects for grouping items together.

 

Within Issues we accrue the Timesheets time into a calculation field called "Actual Effort" that is then used in the Projects app to calculate the Average Time per Issue for the Project.

 

This all works great !

 

However - I'd like to automatically suggest an Estimated Time within the Issue based on the selected Project - such that we can have a more "intelligent" estimate as it's based on past experience.

 

A "Project Average" within the Issue so we can see how each Issue is performing against the Project norms.

 

I tried a calculation field in Issues using "@All of" etc but I can't get it to just provide the current Project Average Time per Issue.

 

I've added two screen shots - one of the Project displaying "Average Time per Issue" as 6 hrs/Issue and then the Fields within the Project App.

 

It's the "6" that i want to refer to in the Issues App when it has the same Project App associated with it.


  • @Andrew Sowden​ from the calc field in the Issues app, if you type out the entire "@all of Average Time per Issue" does it appear in the token list to select? If I'm following correctly this should just be a calc field in Issues with an "@all of Average Time per Issue.join()" to pull that numeric value back from the related Project.

    Selected as Best
  • @Andrew Sowden​ from the calc field in the Issues app, if you type out the entire "@all of Average Time per Issue" does it appear in the token list to select? If I'm following correctly this should just be a calc field in Issues with an "@all of Average Time per Issue.join()" to pull that numeric value back from the related Project.

    Selected as Best
  • Hi @Joel Hall​ - I must not have cleaned up the calculations properly. I kept getting a invalid token message trying that yesterday. Decided to delete all the fields and Cleanup the Deleted Fields in the App maintenance last night. Tried your fix this morning and it worked a treat. Thank you.