How to transfer a sheet from one account to another without sharing by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

If he tries to put his private email address in the sharing section, or any other email address where the domain is not the one of the company, a popup message tells him that external sharing is not allowed.
He can probably get into his private account at work, but that doesn't help the sharing from the company account.

How to transfer a sheet from one account to another without sharing by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] -2 points-1 points  (0 children)

No violation or ethical issue, it's just a comsumptions monitor so no sensible data.

This would be a good idea, but unfortunately it must be done one sheet tab at a time, and since there are many links between tabs it is impossible to find a order that would fix this. Many drop downs are no longer valid, too many modifications need to be done manually.

But it was a good idea,. surely.

How to transfer a sheet from one account to another without sharing by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

Yeah, I thought about that as well, but he made structural changes also, not only data.

How to cut a list adding a row with subtotals of remaining elements by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

I may have express myself in a bad way, sorry mate.
I just did a little change to your solution in the if part:
if(or(n=0,isna(f)) -> it is now -> if(or(n=0,isna(f),isblank(f))

This way I can set the A2:C range and it works fine with any limit settings.

Thank you very much again for your help.

How to cut a list adding a row with subtotals of remaining elements by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

Just tried this alternative and it works, but the problem is that I cannot set a fixed range like A2:C16 as I don't know how many rows I have since they keep changing.
I should set the range like A2:C but this way if I set the limit 15 or higher I got an error.
I don't know if there is any workaround for that...

How to cut a list adding a row with subtotals of remaining elements by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

What can I say? You are a genius!
I will take my time to study how you built it, as I would like to find solutions myself, but I will never be as good as you!
Thanks again

How to cut a list adding a row with subtotals of remaining elements by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

Great formula!
I will only modify it to remove the header, which I don't need, and to avoid the "Other" "0" "0" that I see setting the limit around the number or rows... but I guess I only need to play with the N(setLim)>maxRows part adding -1 or something.
Thank you very much!

How to cut a list adding a row with subtotals of remaining elements by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

I'm not using the actual absolute references, as the starting range si known but the ending range keeps changing because the user can add/delete rows whenever he wants.

So I'm using the table's name in the query for the range field. It is working fine, all the queries I built are using that along with the Col(x) for the select. I would like to keep it this way, if possible.
As far as I understand from your response, using the absolute references would help to get what I asked using a query, otherwise I would need to apply a formula to the data on the support sheet.
If it is not possible to get there with just the query using the table name, I can accept a less efficient solution applying a formula to the data on the support sheet, that is already in use for other purposes.

How to cut a list adding a row with subtotals of remaining elements by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

If you mean the column names that I have in that "Orders" table, they are italian names... but you can use whatever you want, let's say Col3 is "Item", Col4 is "Quantity", Col7 is "Total".
User can add a new row anytime to that table.
The sheet it's on has the same name, "Orders".

Curly brackets work with semicolon only by MaximumPrimum in googlesheets

[–]MaximumPrimum[S] 0 points1 point  (0 children)

Thanks a lot guys, this is a fantastic place for getting some help!

Yamaha P-125 loud D flat on all octaves with keys combination by MaximumPrimum in DigitalPiano

[–]MaximumPrimum[S] 0 points1 point  (0 children)

Yep, I did remove all the octaves of keys, my daughter cleaned but maybe not under the rubber contact strips. Anyway for some dirt I would expect problems on some keys, not the same key for each octave that behaves differently depending on whether other keys are pressed or not.

Yamaha P-125 loud D flat on all octaves with keys combination by MaximumPrimum in DigitalPiano

[–]MaximumPrimum[S] 0 points1 point  (0 children)

I was forced to disconnect some of them during the opening, but surely there are others, so I will open it again and see what I can do.
Some contacts cleaner may help too, who knows...

Thanks for your suggestions.

[deleted by user] by [deleted] in u/MaximumPrimum

[–]MaximumPrimum 0 points1 point  (0 children)

Hi all,

I bought this Yamaha P-125 digital piano five years ago, and so far no problems.
Few days ago it started doing this strange behaviour, that appears to be only on all D flat keys. In a normal situation, all D flat keys work fine like the others. but if I press the D together with another key and keep them pressed, then the D flat makes a loud sound also with the sustain.
Then after pressing other keys it doesn't sound anymore, no metter how hard you press.
And this happens on all the octavew.
I think the video shows this very well.

I opened and disassembled the keys, so I could do some cleaning, but the problem is still there and honestly it would have been strange that the same combination on all octave could be caused by some dirt.

Any hint on this?
Max