[Question] Google Sheets Help
[Question] Google Sheets Help
Hey, I need some help fixing my Google Sheets. Basically, I want to make the sheet work better by automating parts of it so things are easier for me. Here is the first problem: This sheet already works automatically because it gets updated when I submit a new order from JotForm. It updates perfectly all the time. But now I need the B column to find the Company name in different tabs that I have created. For example, if the "Completed Card Order Form Data (DO NOT TOUCH)" tab is updated, the sheet should check: IF the company name equals 6th Gear Contracting OR any other company name, THEN open the tab "6th Gear Contracting" or another company name for me to use as an example. So that's my second problem: After finding the correct company tab, the sheet should now look at Column C and go: IF card number matches the card number on the 6th Gear Contracting page, then delete that row. Third problem: After deleting a row, the sheet should now look at Column D and go: IF any new numbers appear in there, add a new row and put Unit # and Card # into it. But I will have many tabs with different company names, so it would be really nice if I could somehow automate this process easily. Any help would be greatly appreciated!
I use Access every day. It comes with many built-in templates that fit lots of jobs. One thing like this is probably very close to what you need. It won't be perfect, but it will get you almost there. Things like orders and inventory or billing work well here too. Sheets in Excel are good for what they do...they're simple calculators. Very complicated ones even though. Word is also good at what it does. A typewriter. Access and its cousins are great (well okay) at what they do. Don't jump over the streams.
To start here, check the LOOKUP Functions by Type and Name at this link: https://support.google.com/docs/table/25273?hl=en VLOOKUP might also help. You can find lots of other tutorials online just by searching for "how-to's" or examples. = = = = That being said, a database would work better since I think you need something like that. As time goes on, spreadsheets get messy and hard to keep in order.
Yeah, I got that right. I'm just testing out sheets because they're free. What should I do here with a database? I've used Access before but it's been a while since I touched it.
I use Access every day. It has many built-in templates that work well for all kinds of things. One of those is probably just like what you need, even if it's not perfect, but it'll get you pretty close. Things like orders, inventory, and billing. Sheets and Excel are great at what they're designed for... simple math stuff. Access and its cousins are okay too (well good enough) for their jobs. Don't try to mix the streams together.