Automated Timesheets

Options
Andrew Skaggs
Andrew Skaggs ✭✭✭
edited 09/21/23 in Formulas and Functions

Hello,

I'm not sure if this is the correct section to ask this, so if not then I apologize. I'm looking into the possibility of creating an automated timesheet system using a scannable barcode (or QR code), so that once scanned, there is an automatic "clock in" or "clock out".

In testing I was able to scan barcodes/QR codes without issues, however after scanning a manual adjustment of time needs to be made.

My question is if I'm overreaching functionality or is this idea possible? Am I able to point a Time formula to a cell or column in order to record the time of a scan? I'm just not sure what to do so any help would be appreciated.

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!