# Resource Allocation at a given date **URL:** \ **Category:** Ask the Community\ **Created:** [September 4, 2021, 3:38pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433 "2021-09-04T15:38:42Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Johan\_Bertin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johan_bertin/32/20556_2.png) [@Johan\_Bertin](https://connect.superhuman.com/u/Johan_Bertin)\ **Post date:** [September 4, 2021, 3:38pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/1 "2021-09-04T15:38:42Z")
Hello All, I need to schedule the resources allocation as part of an integration project where the workload is the same across the defined period (eg: engineer is working 55% of his time between January and April). We only calculate resource allocation on a monthly period and man days per month. I created a table where I choose the task that gives me the utilisation and I pick the starting month which based on a predefined duration (in month) will give me the end date. ![image](https://global.discourse-cdn.com/coda1/original/3X/6/b/6b58e112d8128a378224942fae39290f3d3e2574.jpeg). I obviously allocate several tasks for the project. So I have the following value for now: - task (manual) - starting date (manual) - Duration (predefined - in months - task attribute) - end date (calculated based on starting date and duration) - Workload (predefined - pourcentage - task attribute) What I would like to achieve is to be able to get the utilisation of a resource at any chosen date for all the tasks (additional filters might be added like company, project, etc). Is it something achievable? Thank you in advance again for your assistance, Johan ---
**Author:** ![Johan\_Bertin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johan_bertin/32/20556_2.png) [@Johan\_Bertin](https://connect.superhuman.com/u/Johan_Bertin)\ **Post date:** [September 4, 2021, 4:13pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/2 "2021-09-04T16:13:12Z")
Thinking differently - Would it be possible to fill the column with utilisation if the title of the column (not necessarily the value tested) is between the task period I detailed my thought in bellows screenshot ![image](https://global.discourse-cdn.com/coda1/original/3X/b/e/bedc78552423388597b14f10831430c7a4e5a462.jpeg) ---
**Author:** ![Johan\_Bertin](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johan_bertin/32/20556_2.png) [@Johan\_Bertin](https://connect.superhuman.com/u/Johan_Bertin)\ **Post date:** [September 4, 2021, 4:52pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/3 "2021-09-04T16:52:40Z")
Got it to work with the following formula. ![image](https://global.discourse-cdn.com/coda1/original/3X/8/3/835e5be5fb2634d9254ee1cadcafc7031b51d698.jpeg) Not sure it is the most efficient one, any recommendation? I have a date database that can be used but not sure how - for example Jan 21 column could pick the Jan 2021 date ![image](https://global.discourse-cdn.com/coda1/original/3X/6/5/65a5bbb511c69903ed50041cac8959cd3e7d2c4a.jpeg) ---
**Author:** ![Diego\_Delfino](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/diego_delfino/32/48445_2.png) [@Diego\_Delfino](https://connect.superhuman.com/u/Diego_Delfino)\ **Post date:** [November 11, 2025, 5:34pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/4 "2025-11-11T17:34:20Z")
Just bumping up the post because it’s a very interesting topic and I didn’t see any example so far. I’m stuck in the same situation where I have a Team Table with Task, Dates and Occupation %, and I’m trying to recreate something similar to a Capacity Planner I once saw in a video from @Scott_Collier-Weir. The only problem I have is I cannot put together an helper column with all the week numbers and the Team table… https://coda.io/embed/b_2ubhYu_2/_suaQ_0do?viewMode=embedplay ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [November 11, 2025, 7:13pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/5 "2025-11-11T19:13:51Z")
hi @Diego_Delfino , your doc cannot be found (something in your settings I guess), my feeling is that this blog post I wrote recently may help you out since it seems to talk about a comparable issue (resource planning). > **[From Project to Action](https://huizer.medium.com/from-project-to-action-3c7d4fb2b0cf)** > > A Coda Deep Dive in Advanced Project Management Today I wrote a follow up blog on it, you find here: > **[Beyond Coda’s AddRow](https://huizer.medium.com/beyond-codas-addrow-c0e36f2b0256)** > > Mastering the ‘Existing Row’ Check I hope it helps, if not feel free to adapt your settings so members of the community can have alook at your doc and help you out. cheers, christiaan ---
**Author:** ![Diego\_Delfino](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/diego_delfino/32/48445_2.png) [@Diego\_Delfino](https://connect.superhuman.com/u/Diego_Delfino)\ **Post date:** [November 11, 2025, 7:50pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/6 "2025-11-11T19:50:28Z")
Hi Christiaan, Now I think the doc should be visible… Thank you for the links, I’m actually subscribed to your Medium account and I’m going through them as I’m learning Coda. They are very useful ☺ I’ll try to have a look at the links and see if I can make some progress. Cheers ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [November 11, 2025, 8:08pm UTC](https://connect.superhuman.com/t/resource-allocation-at-a-given-date/25433/7 "2025-11-11T20:08:36Z")
it is indeed visible, it is evening here maybe I have some time tomorrow or skilled people like @Pablo_DV can maybe help you out 😉