I added the pivot table extension to my base hoping I would be able to somehow extract the data I have it calculating (Avg. Weeks of Completion based on project category). Has anyone attempted this or found a way to do this? I am on the cusp of being able to use our already amazing workflow to project lead times of projects coming through based on recently completed projects. Any help would be appreciated!
Yeah, I would suggest you use an automation to keep the project category field and linked field in sync. Since rollup/lookup fields show the current cell value of the linked record all the time this usually solves the problem for me