Time Entry Form & Tracker

Derrek Davis

I have tried this many ways and solved it in a very rudimentary way but hoping someone here might be able to give me a better solution as it is something we need to have access to at our company regularly.

Problem: I have numerous team members on a project and I need them to enter time for the week at the end of each week on Friday. They are dispersed so I would like to send them a form each Friday and ask them to enter their time for the project. I'd like that entry to add automatically to the smartsheet, creating a new line for the person, date and time entered.

The issue I can't solve is how to get smartsheet to add a line, and not write over the previous entry. I can get the form, send it, get time, but week 2's entry over writes week 1.

Your assistance is greatly appreciated.

Paul Newcome

Are you able to provide more details and possibly some screenshots? Forms should not be overwriting rows but should in fact be entering new rows. Update requests will overwrite though.

Derrek Davis

I have since found a solution that is a workaround, so I no longer have the old smartsheet that was overwriting. Now I just have a long list of weeks with each person in it that generates a form on the day in the cell (the Friday of the week) at Noon, and then enters the time in that line. It works but requires me to create new weeks each week to generate it, or to create 2 years of weeks for a long project.

Paul Newcome

How are you utilizing this data after it is collected? Are you displaying it somewhere (such as most recent entry), or are you just recording the data and possibly running metrics on it?

Derrek Davis

Just recording and reporting monthly to the client, but basically that is just an "all entries between" simple report.

I think I may have found the solution though...I had been trying it through a form. It appears I overengineered it and instead should have just done an hours update via workflow each week on Friday. So...testing that now to see.