Field Employee time tracking software that integrates with Smartsheet?
I'm looking for a time tracking solution for field employees that integrates with Smartsheet. In our organization we have a master project list sheet that compiles project data for all of our active projects. Our field installers are currently logging their time using T Sheets, they're clocking in/out as well as selecting job codes and tasks throughout the day. We're currently running reports in T Sheets then manually entering the data from those reports into our master project Smartsheet. I'd like to either integrate T Sheets into this Smartsheet where the time logged for each project/task updates those cells for that project. In a perfect world we would also have T Sheets import the list of current projects from the project name column on the master project Smartsheet. I know that both platforms have open APIs but where should I start to make something like this a reality? We are open to switching to a different time tracking platform if it means easier integration with Smartsheet.
Comments
-
Andrée Starå ✭✭✭✭✭✭Hi Jodi,
I'd be happy to have a talk and discuss what would be the best solution for you.
Let's start with a free discovery call. How does that sound?
Please e-mail me at[email protected]and well take it from there.
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
-
Richard Rymill SBP ✭✭✭✭✭✭Hi Jodi
This is a common request for Smartsheet users, so much so we have built a range of variations of this solution to match client precise needs. From complex to fairly straight forward as is your example.
We COULD use API code specially written for you but I doubt we need to. We can almost certainly modify one of our out of the box solutions at fairly low cost.
So we use Appsheet as the Mobile user Interface which connects with Smartsheet and provides conditional logic entry (not possible in Smartsheet alone) for your users to complete a form on their mobile device by choosing from lists originating in Smartsheet. The resultant data entry syncs with Smartsheet, so matching work completed to Budgets, Projects and Workers and their team leaders.
Here is a short video we recorded explaining this. We offer a free initial consultation for a demo and Scope discussion so we can provide you with a quotation for your approval.
https://www.smarterbusinessprocesses.com/team-timesheet/
Email me to arrange the initial discussion and demo?
Happy to help.
RichardR
Categories
=IFERROR(INDEX(DISTINCT(LOWER(<\/strong>COLLECT(.....................))<\/strong>), 1), \"//www.santa-greenland.com/community/discussion/42541/\")<\/p> I haven't tested it yet, but I feel like it should work.<\/p>"},{"commentID":386435,"body":" Right. There are already a number of posts here in the community detailing how to pull a distinct or unique list from another sheet via formula. It usually involves the formula above without the LOWER function. The number 1 would output the first distinct value. Changing that to a 2 will output the second distinct value, so on and so forth. I usually use a helper column with the numbers manually entered so I can apply it as a column formula.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"}]},{"discussionID":107674,"type":"question","name":"API PUT and Body help for Cell link from a cell in sheet \"a\" to sheet \"b\"","excerpt":"I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT: https:\/\/api.smartsheet.com\/2.0\/sheets\/4098048888098692\/rows\/1370574824361860\/cells\/259016080 Body: { \"cells\": [ { \"linkinFromCell\": {…","snippet":"I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT:…","categoryID":320,"dateInserted":"2023-07-17T16:23:24+00:00","dateUpdated":"2023-07-18T10:24:44+00:00","dateLastComment":"2023-07-18T16:45:05+00:00","insertUserID":135530,"insertUser":{"userID":135530,"name":"Carlo Rodriguez","url":"https:\/\/community.smartsheet.com\/profile\/Carlo%20Rodriguez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T15:50:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":135530,"lastUser":{"userID":135530,"name":"Carlo Rodriguez","url":"https:\/\/community.smartsheet.com\/profile\/Carlo%20Rodriguez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T15:50:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":60,"score":null,"hot":3379310909,"url":"https:\/\/community.smartsheet.com\/discussion\/107674\/api-put-and-body-help-for-cell-link-from-a-cell-in-sheet-a-to-sheet-b","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107674\/api-put-and-body-help-for-cell-link-from-a-cell-in-sheet-a-to-sheet-b","format":"Rich","tagIDs":[472,563],"lastPost":{"discussionID":107674,"commentID":385785,"name":"Re: API PUT and Body help for Cell link from a cell in sheet \"a\" to sheet \"b\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385785#Comment_385785","dateInserted":"2023-07-18T16:45:05+00:00","insertUserID":135530,"insertUser":{"userID":135530,"name":"Carlo Rodriguez","url":"https:\/\/community.smartsheet.com\/profile\/Carlo%20Rodriguez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T15:50:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-18T16:45:08+00:00","dateAnswered":"2023-07-18T11:38:00+00:00","acceptedAnswers":[{"commentID":385713,"body":" Hey @Carlo Rodriguez<\/a> <\/p> This is how I've successfully added a cell-link using the API:<\/p> PUT (with the destination sheet data): <\/p>
<\/p>
<\/p>
![\"CF](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/C9LJSZDFAE96\/cf-1-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"CF](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/4GOLOWA0NNC7\/cf-2-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"CF](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/CGX9RWPP81B0\/cf-3-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"CF](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/BEG81B5HTCF7\/cf-4-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"CF](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/Q74IPCBDM40K\/cf-5-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
