Logging task start and completion times to excel or google sheets

English Forum Tips and Tricks
, , ,
1

Hi, I’m new to Asana and the forums.

I had a question about logging start and completion dates for tasks. We’ve created templates in Asana for our team’s repeated tasks for things like inspection, shipping, and document preparation. What we would like is to log the date a team member starts and completes a task. We would then like to have this data put in a spreadsheet to analyze turnaround times. Is there are a way to this in Asana either using a built-in setting or an third party integration?

These tasks can take days or weeks to do depending on the product, so an hourly time tracker app integration does not fit our needs.

Thank you!!!

2

Hi @areeb, welcome to Asana and the Community Forum! :tada:

In this case, you can export your project to CSV and your file will include:

  • Created At
  • Completed At
  • Last Modified
  • Start Date
  • Due Date

Screenshot 2020-08-13 at 10.13.56
Screenshot 2020-08-13 at 10.13.561040×700 62.3 KB

Please note that once you export your CSV file, you’ll be able to convert it to excel or google sheets.

I also recommend you checking all the time tracking integrations here.

I hope this helps! Let me know if you have any follow-up questions.

1 Like
3

Thank you @Emily_Roman! The start date function was exactly what I was looking for! And will check out the time tracking integrations page. :grinning:

1 Like