Is anyone familiar with a good formula to show the time tracking for sub-items as a value at the parent item level so I can then display it on a dashboard?
Here’s a screenshot showing the time tracking rollup onto the parent. I can’t seem to figure out a way to get the parent line item
Hi Charlie,
Try adding a formula column on the parent item and use the following formula:
CONCATENATE(ROUND((({Time Tracking Rollup}/60)/60), 2), " Hrs")
This will convert the time on the Time Tracking Rollup column to the number of hours invested in the subitem and add the “Hrs” sufix for visualization.
Please let me know if it works.
Good luck!
Shiro
Hello Shiro, apologies I did not get back to you yet. I figured it out but I like your nice touch of adding the “Hrs”. Thanks!
1 Like