Google Sheets help

[Yo ssi]

App sheet is an interesting thought (it costs IINM), it's definitely possible with an app script

[bubbles]

i have a google sheets where i keep track of all my items that we import each line has the model number, cost, container number, ship date, landing date etc..

since there are so many its hard to see exactly which models are coming when.  i would like to have sheets (named by the model number) for each model number so that when we add a line onto the main sheet it should copy straight into the correct sheet. that way i can see each model separately.

what would be the best way to do this?

You actually need to copy the row? Then you'd need a simple script. But if you just want to view it why not just use a filter formula?

[lubaby]

You actually need to copy the row? Then you'd need a simple script. But if you just want to view it why not just use a filter formula?

Pivot Tables would likely also work.

[sillypainter]

We recently started using airtable.com. didn't know until recently such a powerful thing even existed. Check it out if you're in spreadsheets.

[SamDaMan]

i have a google sheets where i keep track of all my items that we import each line has the model number, cost, container number, ship date, landing date etc..

since there are so many its hard to see exactly which models are coming when.  i would like to have sheets (named by the model number) for each model number so that when we add a line onto the main sheet it should copy straight into the correct sheet. that way i can see each model separately.

what would be the best way to do this?

i did a little googling and this worked for me

=filter(Master!B:N,Master!B:B="SKU NAME")

[etech0]

i did a little googling and this worked for me

=filter(Master!B:N,Master!B:B="SKU NAME")

You can put that in row b and in a cell in column a let the user choose a SKU (you can use data validation to give a dropdown), and then refer to that in the formula.

[Yo ssi]

CTR + Down
Just came pretty handy

[Yr18]

Is there a way to set up a notification email when a specific person edits a shared sheet and not every edit made

[Yo ssi]

Is there a way to set up a notification email when a specific person edits a shared sheet and not every edit made

Not simply. Possibly with a script

[m65]

i keep almost all info that i constantly update on google sheets, taxes, P&L, cc and bank balances etc
as of tonite a bunch of them are not editable, some are and some arent
what can i do to fix this?

[yesitsme]

i keep almost all info that i constantly update on google sheets, taxes, P&L, cc and bank balances etc
as of tonite a bunch of them are not editable, some are and some arent
what can i do to fix this?

Are you the owner?

[m65]

Are you the owner?

yes

[chulent613]

i keep almost all info that i constantly update on google sheets, taxes, P&L, cc and bank balances etc
as of tonite a bunch of them are not editable, some are and some arent
what can i do to fix this?

Is it possible that your computer is offline or blocked by a filter?

Try from a different device.

[m65]

Is it possible that your computer is offline or blocked by a filter?

Try from a different device.

filter wouldnt block some and allow others, although u never know with all their bugs
either way today they started working again

[Definitions]

I'm pretty sure Google sheets used to show the format of functions when typing it in. Now I don't see it anymore. Is there a setting that turns it on?

[Yo ssi]

I'm pretty sure Google sheets used to show the format of functions when typing it in. Now I don't see it anymore. Is there a setting that turns it on?

What do you see now?

Generally it's always there

[Definitions]

What do you see now?

Generally it's always there

Nevermind I'm a klutz it opens when I click the blue question mark next to the cell I'm editing

[Definitions]

How do I conditionally format each row from column A to column J to have a background color if the cell in column A is a date less than 3 days from now?
I set the range to be A2:J and put this in as the custom formula.

Code: [Select]

=A2<=TODAY()+3

But its not working.

[etech0]

try this

Code: [Select]

=$A:$A<=TODAY()+3
Or if you don't want blank rows highlighted:

Code: [Select]

=AND($A:$A<=TODAY()+3,$A:$A<>"")

[Definitions]

Or if you don't want blank rows highlighted:

Code: [Select]

=AND($A:$A<=TODAY()+3,$A:$A<>"")

This worked perfectly. Thanks.

ETA this worked too apparently
=AND($A2<=TODAY()+3,$A2<>"")