Calculate and populate a field on story form based on scrum tasks

Rose17
Tera Contributor

Hi all,

The requirement is- I have a field named as 'Efforts' on story form.

I want to calculate the sum of actual hours of all scrum tasks for a story record and populate the calculated value in 'Efforts' field.

For eg- if i have 3 scrum tasks- A,B,C for a story record-'test' having actual hours as 2,4,6. I want to calculate the sum of actual hours of all three scrum tasks(A+B+C i.e 2+4+6=12) and populate calculated value(12) in 'Efforts' field of story- test.

Could someone help me to achieve this?

Thanks in advance

15 REPLIES 15

@Rose

Hope you are doing good.

Did my reply answer your question?

Would you mind marking the best matching answer as correct and helpful, to close this thread so that it benefits future members?

Regards
Ankur

 

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader