Secret Automation Trick to Skyrocket Your Team's Productivity Without Them Knowing!

[@excelissimple]

Check more DIY Task Trackers here: kzbin.info/www/bejne/qIrXZGmNi6x7eqc

[@anandrengasamy874]

superb one and i appreciate the effort you put in to develop this template

[@anta-oelinchannel]

Thanks for sharing this information. I didn't get how to set the filter so that when the the task is completed, it will not be shown in the pivot table?

[@accountsvalue]

Thank you, a useful tracker to focus team tasks. Thank you for taking the effort, time and sharing.

[@excelissimple]

Glad it was helpful!

[@CKOM21]

Thank you sir.Can you please tell you how can I make a tracker to monitors the study hours of different students filled by them every day.

[@Zf-lt7tv]

Really enjoyed the Video; keep the good work going 👌👌

[@hareshhemvani4781]

Hi great work I just wanted to know that what after 16th row as per your example is it every time I have to insert an if error function if there are more entries ie after 16th row 🙏

[@dieguis12]

What would happen if someone fills out the form for a job that was already filled before? For example, I want to update the status of the job from pending approval to done. That would require the employee to fill the form twice. How can I overwrite an existing row in the form response tracker?

[@excelissimple]

Hi Diego, this is quite an important question as there could be instances when people are filling the form twice or more. First of all let s understand that the form responses are being recorded in a google-spreadsheet; so all of your responses will stay recorded. However, since we are using a VLOOKUP function in the master tracker, the first recorded response for a task will be shown up. To link the latest response in the task tracker, you will need to remove the earlier response(s) in the form responses sheet.

[@9804722782]

Brilliant. Need more consultation, how to connect ?

[@Syeidin]

Suppose I've 50 employees who are doing 4 tasks daily. Now I need a mechanism which will help me track their daily activities where they are the ones who report and i get a automatically generated google tracking sheet which will also arrange the data in a pattern that will help me resulting a monthly report. Do you understand, or i can elaborate in a private mail or messenger. This will help me keep my job.

[@comtekbizsoft]

Very nicely explained 👍

[@excelissimple]

Glad that you liked it

[@mehulmevawalla5208]

If I require particular employee to watch only his data, what would be the step. Also if sheet data can be seen on Google form and they can just tick all work assigned with completed date Thanks in advance

[@excelissimple]

Hello Mehul, Here is what you can do. Create individual pivots for each employee and save each pivot as a separate URL. Share the respective URL with the employees.

[@johannestestlab4934]

Are there anyway of selecting job ID and employee ID from the database already in the gsheet so that the user don't have to type, but just dropdown to choose?

[@excelissimple]

Thanks for your query. One way to do so is to add these as dropdown while creating the forms. Also, since we are also publishing the pending tasks as a webpage; once can anytime copy and paste from the webpage.

[@carriecoffey4846]

Hi, do you have a template for this?

[@sonoffindia5209]

please share the temple sample

[@cheerful293]

how to generate monthly report from this tracker? Thank you

[@excelissimple]

If you want to create a monthly report, just add a column in the master tracker where you have the month. It can be done manually or you can extract the month from the date using TEXT function. Then using pivot tables or IFS functions you can generate the monthly report.

[@Nova_Axel-S21]

Thank u so much

[@excelissimple]

Most welcome 😊

[@livius4653]

Interested in designing something for me?

[@excelissimple]

Sure, why not

[@gantulgaerdenechimeg3520]

Too long. Not professional

[@excelissimple]

Thanks for the feedback. Will make shorter videos going forward.

[@dieguis12]

@@excelissimple I thought the length was perfect. It was detailed and I really enjoyed it!