How to add a timestamp to sheet.

romeoffice@tsdrome.com

Hi All,

So I am trying to build a production tracker for my company. Part of what the owner wants is for the personnel on the manufacturing floor to be able to scan their ID cards with a scanner and go into work with a piece, and then repeat the same process when the are finish and get out of work with the piece they were working on. I have seven different manufacturing stations for each piece, and I need some kind of automation to happen when they scan their ID's that it automatically enters in a date and time of when they scanned their ID's for each piece, and then automatically enters a date and time when they leave work on a piece. I know date and time stamps are possible within Smartsheets, I am just not certain how to go into my sheet and set it up. Any help would be greatly appreciated.

Heather Duff

Hi!

So, I'm not super familiar with the barcode scanning, etc.; however, I do know how to add a timestamp column. What you'll want to do is add a column that set as an Auto-Number/System-Generated column, and select Created (date).

This will make a timestamp for when the entry was created. Hope this helps!

Best,

Heather

Andrée Starå

Hi @romeoffice@tsdrome.com

I hope you're well and safe!

This might help.

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

romeoffice@tsdrome.com

https://community.smartsheet.com/discussion/comment/282262#Comment_282262

So I did this method. Issue is I have fourteen different entries to do like this. Two for each manufacturing station (In work/Out of work). The copy row automation to another sheet was fairly straight forward. After a couple videos I figured out the VLOOKUP function and was able to get a return from my secondary sheet that I sent a copy of a row. At first it kept saying #INVALID COLUMN VALUE, which I figured out meant that because I was pulling data from a column formatted for dates, I had to paste it into a column formatted for dates as well. While I was able to pull successfully from the data sheet to the parent sheet, its only pulling the date information and not the time information.

Andrée Starå

@romeoffice@tsdrome.com

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.