I’m looking for a way to deal with my team members’s rates and their tasks.
- a table ‘TEAM’ with a list of ‘People’ (who are my Coda team members) and their ‘Hour rates’.
- a table ‘TASKS’ with a list of tasks, ‘Hour estimates’, and ‘Cost’ (which is ‘Hour estimates’*‘Hour rates’)
So, I’m assigning a task that has a defined ‘Hour estimates’ value to a team member —> the person gets it in his list of tasks while I see what is the estimate cost of this task, based on the calculation of the task hour estimation multiplied with a hour rate of a person the task is assigned to.
I know that it can be done with two steps:
- assigning a member to a task, so he/she will see it in his/her task list
- setting a person to get info about his/her hour rate to calculate the estimated task cost
It looks dumb to assign the same person twice.
What I’m trying to achieve is to be able to get a task’s ‘Estimated Cost’ after assigning the task to appropriate person in a single step.
Is there a way to make it?