Automated Timesheets

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


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!