TrackingTime integration

jafarh

Hi all,

I need a time tracker. I found TrackingTime Chrome Extension. The website says that all I have to do is add the following formula somewhere on the sheet:

=”TrackingTime:”+Task Name column+”,,”+Project name column

My formula is:

=”TrackingTime:”+Primary+”,,”+Details

I get the following error:

#UNPARSEABLE

The extension is enabled. Any suggestions?

Jason Tarpinian

It looks like you are just missing the @row on the end of your column references.

jafarh

Thank you, I added:

=”TrackingTime:”+Primary@row+”,,”+Details@row

but did not help. For project column are we just looking for column called Project Name

Mathieu PERSICO

Hi @jafarh ,

Looks like the quotation marks you used are not correct:

Try those " instead of ”

="TrackingTime:"+Primary@row+","+Details@row

jafarh

Thank you so much for all the wonderful suggestions. Mathieu suggestion fixed the issue. This is what the script should look like:

="TrackingTime:"+[Task Name]@row+","+[Project Name]@row

This gives a button in the row. I hope TrackingTime will change this on their website

Paul E Rayburn

FYI Mathieu PERSICO formula works. jafarh last comment formula does not. At least I could not get it to work.