Traking user productivy

[LauLopezF]

Hi Friends! Can someone please help me with this? I manage a small team of 3 members. Let's say I have 3 tables:

1. Projects,

2.Tasks and

3.Subtasks (

linked with one another).

So I have an interface where each user can see everyday the projects, tasks and subtasks asigned or due for that certain day.

I want a way to track productivity, or what have been done each day by each user, in someway that is simple and ideally automated.

Do any of you have any idea of the structure I must follow to accomplish this?

Thanks in advance

[TheTimeSavingCo]

Assuming you have a checkbox field for each user to mark when they've completed a task, you can use the time they modified that checkbox as a way to track when they completed it.  To do this, try:
1. Create a "Date time" field
2. Create a "Last edited time" field that looks at the checkbox field
3. Create an automation that'll trigger whenever the checkbox field is marked, and have an "Update Record" automation that'll paste the value from the "Last edited time" field into the "Date time" field

Now that you have the date a task was completed, you can use views or Interfaces to see how many tasks were completed on a specific date