Best way to capture data from the field

Bwoods113

Attached is a picture of a daily report form that we capture from each crew on a daily basis. These are done on paper and handed in weekly. Looking into how we can utilize smartsheets to get this information on a daily basis and digitized. My first thought was to create a form to gather all this info, I soon realized I will have more than 100 columns to capture for all the possible trucks, deliveries, and subcontractors. Wanted to see if anyone has come up with something better than a very lengthy form. Any thoughts are greatly appreciated.

Daily Marked Up.pdf

KPH

Hi @Bwoods113

Could you create a sheet with just the columns that you have on the paper sheet and use a drop down for each truck, delivery, subcontractor?