Best way to capture data from the field

Bwoods113 ✭✭
edited 03/27/24 in Smartsheet Basics

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.