TrackingTime integration

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?

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.