Question Google Sheets Help

May 4, 2021
5
0
10
0
Hello, I need some help regarding google sheets, basically, I need to automate part of my sheet to help with the workflow.

First Problem

this is an automated sheet that is updated with jotform that updates whenever we submit a new order, this works perfectly. but I need the B column to find the Company name in the different tabs I have, so for example, when the "Completed Card Order Form Data (DO NOT TOUCH)" tab is updated, google sheets will go, "IF company name = 6th Gear Contracting, or any company name, THEN open tab "6th Gear Contracting or another company name, I am just using this for an example.

Second Problem

so, after the sheet finds the company tab, the sheets should now look at column C, and go "IF card number matches card number on the "6th Gear Contracting" page, delete row"

Third Problem

after the sheet deleted the row, it should now look at column D and go, "IF any new numbers present, Add row and populate with Unit # and Card #"

but I will have multiple tabs with different company names, it would be nice if I could somehow automate this. any help would be greatly appreciated.
 

Ralston18

Titan
Moderator

USAFRet

Titan
Moderator
Mar 16, 2013
141,047
7,843
174,040
21,794
As above, this use case screams for an actual database, not a spreadsheet.

I do this literally all the time....Converting a 'spreadsheet' that has seriously outgrown the capabilities of Excel or Sheets.
Yours is starting at that point.
 
May 4, 2021
5
0
10
0
yeah, figured as much. just trying to see if sheets would work cause of the "free" aspect of it

any ideas as to how to do this with a database? ive used microsoft access before, but am a bit rusty
 

USAFRet

Titan
Moderator
Mar 16, 2013
141,047
7,843
174,040
21,794
yeah, figured as much. just trying to see if sheets would work cause of the "free" aspect of it

any ideas as to how to do this with a database? ive used microsoft access before, but am a bit rusty
I use Access daily.
Access has a bunch of built in templates, for all sorts of uses.

One of those is almost certainly close to what you can use.
Not 100%, but will get you most of the way there.
Orders, inventory, billing, etc, etc.

Sheets and Excel are great for what they are...calculators. Very very complex calculators.
Similarly, Word is great at what it does. A typewriter.
Access and its equivalents are great (well good) at what they do.
Don't cross the streams.
 
May 4, 2021
5
0
10
0
I use Access daily.
Access has a bunch of built in templates, for all sorts of uses.

One of those is almost certainly close to what you can use.
Not 100%, but will get you most of the way there.
Orders, inventory, billing, etc, etc.

Sheets and Excel are great for what they are...calculators. Very very complex calculators.
Similarly, Word is great at what it does. A typewriter.
Access and its equivalents are great (well good) at what they do.
Don't cross the streams.
which template are you referring to? that sounds like what we need
 

ASK THE COMMUNITY

TRENDING THREADS