We use Smartsheet for our logistics business, from booking until invoicing. One row has appr. 160 columns. Currently we use excel for data input, as we can put the data for 1 row in a spreadsheet overview. If we use the row view from Smartsheet, there is only one column and all items are below one another.
I added a screenshot of the excel file. The dark green fields are column headers, and the inputted data are the rows. We upload the data from each excel form and copy this to the main Smartsheet for our operations.
Ideally I would be able to see a Smartsheet row in this excel lay out. Is there such a view option, or can it be created? (for example, a dashbord view that I can design based on the columns in my grid?
Right now, we created a downloadable PDF so we have a easy overview, but of course, we cannot update any data through that.
Can anybody tell me whether the row view is the best Smartsheet can offer, or I can design my own "dashbord" per row from my grid?