+2What is the calculation behind the Timeline Utilization summary? I am trying to create a formula column that displays a resources utilization in the Resources table, to be used as a metric on a landing page.
I tried ((({Task Count} * 8) * {% Commitment} ) / (40 * {% Availability)) , but it does not match what AirTable is showing on the Timeline view. The task count is the number of tasks for the current day.
Is there a way to simply access the calculated value?
Thank you,
+31Hm, could you provide screenshots of your table set up that’s populating the timeline view with some example data and the utilization figure?
And you’re trying to display the utilization on a weekly basis for a single person, is that right?
+2
Hopefully the attached image is helpful.
What I am trying to do is create a %Utilization formula column that replicates the values AirTable shows on the timeline.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.