Calculate the Sum of custom field across projects

[anthony_butler]

Hi,

I have two projects, Incident Management and Problem Management. In the Incident Management project I have a field titled 'Total Agent Hours' that we fill in with a numeric value at the end of every incident to reflect how many hours it has cost us from an end user CS agent perspective. We then link our incidents to problem tickets in the Problem Management project. One problem can have multiple incidents linked to it if necessary. 

I would like to be able to set up a rule or automation that takes the 'Total Agent Hours' value from the incident tickets and returns a sum of them on the problem ticket. I would like this to update each time a new incident ticket is linked to the problem ticket so as to show a running total. For example:

Incident ticket 123 has a value of 10 agent hours, when it is linked to problem ticket 123 the value of 10 is shown in the agent hours field.

Incident ticket 345 has a value of 20 agent hours and is subsequently linked to problem ticket 123. The value in he agent hours field should now read 30. 

Is it possible to set this up using Project Automation? We do have scriptrunner installed, but this seems more complex to set up and I am the only one that can set these things up and I'm not good with scriptrunner! 

Many thanks for your help.

[JMCP]

Same problem here, the problem is with Office 365 not using the FROM description sent by JIRA. When the receiver of the message is outside company (another domain) it shows correctly, apparently Office365 force the use of the boxname for any receiver on same domain. 

Haven't found any solution yet, besides create another domain just for the JIRA email account of course.

[Glenn Skäre]

Hi!

This is solved by following the instructions under "Option 3: Configure a connector to send mail using Office 365 SMTP relay" here;

https://support.office.com/en-us/article/How-to-set-up-a-multifunction-device-or-application-to-send-email-using-Office-365-69f58e99-c550-4274-ad18-c805d654b4c4

[David M]

I've come up against this now, having just migrated to Office 365.

Did you ever get a resolution @Larry Katz?

[Stanislav Zaprudskiy]

Same problem with authenticated on-site Exchange mailbox. Solved it after configuring an anonymous receive connector http://social.technet.microsoft.com/Forums/exchange/en-US/4c32ec59-1d5b-4361-a344-b69f8b203c36/exchange-modifying-the-display-name.

Articles from JIRA KB:
https://confluence.atlassian.com/display/JIRAKB/MS+Exchange+with+Outlook+Strips+the+FullName+Variable+in+Notifications<br< a="">>https://confluence.atlassian.com/display/JIRAKB/Sender+Field+%28%27from%27%29+Displaying+only+Sender%27s+Email+on+Received+Notifications
But unfortunately they are not applicable for O365.