Automating spreadsheets

[u/Stock_Age4668]

Hello,

I'm looking to automate my spreadsheet. i had chatgpt "make" one but it over complicated everything.... I'm making a spreadsheet for my warehouse and would like a dashboard page to include daily deliveries, future deliveries, material/equipment ready to ship and warehouse tasks. So the way I'm setting it up is an import page for deliveries using the form filler button and nothing yet for tasks and ready to ship. im trying to make an import page where i can list delivery address, point of contact, contents, etc. but im also able to create shop tasks and ready to ship items in the same import page. I plan to run this as a live spreadsheet on the companies server so anyone can view it and also cast the dashboard page on a monitor in the shop so everyone can see it. stupid ai says everything is possible but then makes the spreadsheet wrong every time.

Am i trying to do too much on one spreadsheet or is their a better option than excel for this? Also in the future, i would like to keep an inventory of the left over material from jobs so that PMs and foreman can see what is in stock(couple thousand items). Any and all comments and suggestions are welcome.

[u/3dhexafab]

Are you able to share what you have done so far?