Output the time spent precisely by day

Our employees use the custom field “Time Spent” to track tasks. In this process, tasks are also handled multiple times, and time is tracked. It may happen that the due date of the task is postponed. How can the recorded time of the original date be displayed correctly and not on the new due date?

Hi @thomaspreuss , it’s not clear what type of field is your ‘Time spent’ field. Perhaps that will clarify how it is related to your question and the title of the thread. And screenshots always help, too :slight_smile:

To capture the original due date field, you can create another Date type field and a rule to populate that field only if it is empty when the due date of the task is set (so it will run once, the first time the due date is set). You can manually override and change this or if you are on the Enterprise tier, you can apply a field restriction so that only Project Admins can change this.

Then your ‘Time spent’ field could be a formula field that is formatted in days which could be due date minus start date or creation date, depending on your use case.

Hello @Richard_Sather,

Thank you very much for your feedback. I think I may have phrased my question incorrectly. It’s difficult for me to present it in English since all our fields are written in German. I simply want to display all recorded times for the “Time Spent” field in a dashboard or export it via CSV. For the evaluation, however, the recorded time must be accurate to the day. I do not know if the recorded time also shifts if the due date or the completion date is changed. If that were the case, the recorded time would be of no use to me.

In the second screenshot, the correct date (13.03.) is stored. But how can I display/export this in a dashboard or CSV?

I apologize greatly for the poor description! :face_with_peeking_eye:

1 Like

I’m not sure if I can understand exactly what you want.
But you can make a graph by day if you set it up like below:



@Tetsuo_Kawakami Great, that’s what I’m looking for. However, my reports do not include the ability for this setting. We are on Enterprise, but unfortunately still without “Timesheets & Budgets”. Is that the reason?

Hi @thomaspreuss
Timesheets is an add-on functionality. It doesn’t appear in your environment if you don’t pay extra for it. But it doesn’t matter because the option above is not included in timesheets functionality. You can set it up. Note that you have to chose options in order like bar>actual time >time entered date.

2 Likes

@Tetsuo_Kawakami Thank you very much! It actually looks completely different for me, but with some testing I got what I wanted.

2 Likes

Oh! I got what you said. You use a dashboard of reporting.
My picture is a dashboard of project.
That’s why it looks different.

2 Likes