Resource scheduling and tracking in Asana?

@Vai_Cheung @Mark_Hudson My answer may be a little long winded but later this week I am going to contribute a version of my gift to the community CSV To Asana Simple List Generator- My Gift To Community - #24 by James_Carl that I am adding two custom fields Est-Time and Act-Time and a calculated Difference. Having said that the direct answer to your question as provided by @Mark_Hudson is there is no resource allocation tool in Asana but my tool should help those with Windows PC machines. (If a MAC user or two like it I can get you in contact with my programmer and the whole tool will be very little cost to replicate). Here are my thoughts on Resource allocation to do it correctly. I think you need the following information and calculation:

  1. Total Estimated Task Time

  2. % of Assignee Time Available to the Task.

  3. So the Amount of Estimated Task Time is Multiplied by the % of Assignee Time Available to the Task to get a calculated Estimated Task Time-Assignee.

  4. The Assignee then keeps their actual time updated in a custom field Actual Time-Assignee

  5. Of course you could take this as far as you want but it could get complicated as we are trying to create with what is available. So for instance you could have a filed % of Assignee Time Available This Week multiplied by Total Estimated Task Time to do weekly scheduling.

  6. When and if Asana allows mathematics between custom fields this will be a major tool combined with the Advanced Report Writer.

  7. In the mean time you will at least have my CSV tool and the improvement request I have made to Asana. CSV To Asana Simple List Generator- My Gift To Community - #29 by James_Carl.

  8. Here is a sneak preview of what should be done this week. I will be adding subtotals at Project and Grand Total at the bottom of the page. I also am the creator of Sendana, a Microsoft Outlook Add-in for Asana www.sendana.net, if you use Microsoft Outlook. Here is the report, please let me know if you think this would help and @Mark_Hudson if you have any thoughts they are always welcome.

3 Likes