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?
i did a little googling and this worked for me=filter(Master!B:N,Master!B:B="SKU NAME")
Is there a way to set up a notification email when a specific person edits a shared sheet and not every edit made
i keep almost all info that i constantly update on google sheets, taxes, P&L, cc and bank balances etcas of tonite a bunch of them are not editable, some are and some arentwhat can i do to fix this?
Are you the owner?
Is it possible that your computer is offline or blocked by a filter?Try from a different device.
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
=A2<=TODAY()+3
=$A:$A<=TODAY()+3
=AND($A:$A<=TODAY()+3,$A:$A<>"")
Or if you don't want blank rows highlighted:Code: [Select]=AND($A:$A<=TODAY()+3,$A:$A<>"")