Time sheet V2
There are many smaller requests related to time sheet. Hence I am looking for a bigger improvement to tackle majority of them. See the conceptual sketches attached.


There are many smaller requests related to time sheet. Hence I am looking for a bigger improvement to tackle majority of them. See the conceptual sketches attached.


Log in to comment and vote
Comments19
Martynas Gailius
Jan 6, 2025
Vidas Thank you for this update! It is really helpful.
Dec 16, 2024
Vidas
Dec 12, 2024
Martynas Gailius Cecília Ribeiro Giedrė | 2L Joshua Anne Plating Maximilian Welter Diego Villalobos
can you help me understand how you use timesheet and item estimation in this report?
When looking at time sheet report, do you compare estimated hours to tracked hours?
And if you do, what do you do when report is filtered only for part of period for example one month, but the item has more timelogs in other months, does the estimation make sense?
Much appreciated. We are almost finished and trying to iron out the last logic parts.
Cecília Ribeiro
Dec 12, 2024
Vidas Hello!
unfortunately, we don't actually use to compare estimated hours to tracked hours, because we don't estimate hours :(
We do use to analyze in which project (board) our team is spending their time and at the end of the month how was the month.
Vidas
Dec 12, 2024
Cecília Ribeiro: thank you for feedback
Nov 10, 2024
Oct 8, 2024
Vidas
Sep 5, 2024
Marie-Anne Herremans John Stapleton what data would you use for profitability calculation and how would you display it on timesheet? We are on the verge to start this improvement and I am collecting more details.
John Stapleton
Sep 6, 2024
Vidas Also would be good to have some kind of permission settings around this, so that hourly rates are not visible to everyone. :-)
Vidas
Sep 9, 2024
John Stapleton: hourly rates are currently visible only for workspace administrators. But it is of course easy to deduct if someone logs 1h, then rate is clear. So, should the actual profitability calculation be visible only for workspace admins?
John Stapleton
Sep 9, 2024
Vidas I would say "yes". Or maybe only specifically designated people? Just because you're an admin on the system, doesn't mean rates & profitability should be open to you. Probably best to have a special security group and only they can see the rates & calculations.
Vidas
Jan 10, 2024
Marie-Anne Herremans can you specify which data element in your setup represents project? Is it board or row name?
Marie-Anne Herremans
Jan 12, 2024
Vidas: It's two custom fields. One for client and one for project. Now in the timelog you see the ticket number but that doesn't say much. It would be more usefull for us if we woud see the client and the project there. Then we have the title of the ticket and then the hours. That would be perfect.
Vidas
Nov 14, 2022
How would you define profit left? Substract from budget tracked time multiplied by hourly rate? Profit = Budget - (tracked hours * hourly rate)
Olivér Varga
Nov 14, 2022
Vidas: Yeah!
So lets say we agree with a client on a $3000 fix budget.
If we were to magically finish the job with no work, then $3000 is our profit.
But we do work on it, so with our hourly rates (internal) the clock is ticking and every minute we track would subtract from that $3000.
Lets say we have a daily $300 rate, so if we finish after 5 days it would leave $1500 left as profit, but if we would finish after 20 days we would actually lose money on it.
So I imagine a column where yeah, it would show Budget - (tracked hours * hourly rate)
and also have a bar that has a total width for a budget and a fill width that is proportional to the profit. Like a reversed progress bar. The longer we work on it, the less money we get as profit.
Vidas
Nov 15, 2022
Olivér Varga: thank you for clarification!
Vidas
Nov 15, 2022
Olivér Varga: makes absolute sense. We do have formula field in our plans. Will take this among formula use cases and see whether we can put it among first versions.