Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 22, 2022 02:02 PM
Hello all!
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!
Thanks!
Jul 24, 2022 08:55 PM
As far as I know that isn’t possible I’m afraid
If I were you, I would convert that project category field into a linked field to another table and calculate the average there so that I could use it
We could also use a script, but that may be more trouble than it’s worth here
Jul 25, 2022 07:21 AM
Thanks for the info. The problem is that the data is ever changing and the linking fields and putting them to another table only gathers the data available at the time of creation.
Jul 25, 2022 07:12 PM
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