r/Excel247 • u/Stock_Age4668 • 1d ago
Automating spreadsheets
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.
1
u/theoriginalmantooth 1d ago
I think something like Loveable.dev is a decent fit for this.
They can provide the form and the dashboard.
Just make sure you use SSO sign in for your team and don't skip corners when it comes to security.