Ability to add custom field to Timesheets Table
U
Urjit Hirani
It would be nice if we could add any existing custom fields to the timesheets table in the column. Likewise, instead of going inside the task to see the info, it will be visible directly from the Timesheets table.
Log In
M
Mary Vandulken
I found a workaround if you're on a plan where you have free AI cards or if you have extra credits.
Create a dashboard and add an AI card. Our work is work is categorized by tag so you may have to adjust for your workflow. My prompt pulls details stored in the parent tasks as well, you may need to delete that part.
The output Brain provides can be copied into excel or sheets and does not produce anything similar to the existing time tracking UI. Thought I would share anyways in hopes it helps someone in the future :)
In the prompt, enter the following:
---------------------------------------------------------------------------------
Provide a list of time tracked for any subtask with the tag <tag1>, <tag2>, or <tag3>.
Only report on the tasks and subtasks in the following spaces:
<Space 1>
<Space 2>
<Space 3>
Include the <Custom Field 1>, <Custom Field 2>, <Custom Field 3> custom fields from the parent task and the date the time was tracked on.
Do not show the coding, just show results in the format " "tag","<Custom Field 1>","<Custom Field 2>","<Custom Field 3>","time tracked", date the time was tracked on. "
Use <start date> - <end date> as the time period.
Formatting:
One row per individual time entry.
Provide only the name of assignee, do not @them.
Round the time to the nearest minute. With the lowest amount of time being one minute.
Dates should be in the format YYYY-MM-DD.
---------------------------------------------------------------------------------
You might be able to play around with the prompt a bit to make it more efficient but when I deviated from this format Brain would tell me I could only use one space or list to pull data from, or that the time period could be a max of 2 weeks.
Shahen Halebian
I second this. The ability to add custom field columns to timesheets would speed things up for us considerably. Currently, the timesheets are listed by tasks. We use a task as a project and have a custom field where we create a project number per project. We would need the ability to add the project number custom field so we can see the time entries added for each project number, since project number is more relevant to how we search for and know our projects.