What 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,
Hm, 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?
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.