Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,299,512
Community Members
 
Community Events
165
Community Groups

How to assign multiple resources and estimated time per resource to a card

Edited

Can any Trello experts help me here? I've searched high and low for a solution but am struggling.

I'm trying to create a project management board, where each list represents major categories of work, and each card represents specific items of work within the category. 

I want to be able to assign estimated time (days) for multiple resources (staff) to each card, and then set a daily cost per resource, and be able to calculate the total cost for each list and the overall board.

I can see this would be easy enough if there was only 1 resource per card, using members and custom fields. The challenges I need help with are:

1. I need to be able to allocate multiple resources per card each with a different amount of time allocated.

2. Each resources' daily rate (cost) is a fixed value so I'd ideally like to have that in a separate place as like a lookup that every card which has that resource assigned can reference to calculate their total cost.

3. Ideally I would to use a custom field for the resources as we don't yet have real people in these people so no active trello accounts to assign as 'members'. 

Is any of this possible?! Thanks.

2 answers

1 accepted

0 votes
Answer accepted

Hi @Daniel Walsh ! Welcome to the community :) you can create calculated custom fields using butler (see here under Custom field arithmetic).

Maybe you could add custom number fields for each member. For each card, you can input a number in each field which will represent the estimated hours needed for each member.

Then, have another custom field "total hours" that sums up those values for each member. 

On top of that, you can create another field to calculate the total cost by multiplying their hourly rate by the total hours.

You could contain those totals in a separate card on your board. It might be better to have a separate board in fact - that way, you're not cluttering your board with lots of fields.

This is how it would look:

Calculate sums.PNG


Alternatively, Dashcards allow you to sum up values from custom fields. It won't calculate the total cost, but you could just do a quick calculation based on the sums shown in the cards and their hourly rate. So something like this:

dashcard sums.PNG

If you need help implementing the above, feel free to hit me up hannah@simplaworkflows.com

@Hannah Morgan 

Nice!👏

@Daniel Walsh do share your insight on its use should you implement this for your projects.

Like Hannah Morgan likes this

Sounds like exactly what I need thanks!

@Daniel Walsh 

I am not an expert in Clockify. Saw a client using it and found that you can set estimates. 

https://clockify.me/blog/productivity/track-time-in-trello/#Managing_estimates

Thanks for the suggestion, but it doesn't appear to do quite what we need it to do (the interface is also very clunky and unintuitive).

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,392 views 28 41
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you