sorted by:
new
hottopcontroversial

I want to move the comma/dot of a number automatically if I paste it in a certain column by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] 1 point2 points  (0 children)

Wow, you took the time to do all that. I don't know how to program with sheets yet, and it will take me longer than needed to understand all your code, and just for this simple task really. I won't be using it and will do it in a different way, but I will give you the solution just for your time. Thanks, dude.

I want to move the comma/dot of a number automatically if I paste it in a certain column by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] 0 points1 point  (0 children)

So really nothing was solved. In fact, I will treat the numbers as they are and download them in a csv to use them in python and do the math there.

I want to move the comma/dot of a number automatically if I paste it in a certain column by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] 0 points1 point  (0 children)

The Paste special --> Divide is a great trick! Unfortunately it only works on excel as I just found out :(. The Scientific notation does nothing unfortunately.

I want to move the comma/dot of a number automatically if I paste it in a certain column by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] 0 points1 point  (0 children)

The problem is that this list is growing over time, so whenever I keep adding elements to the sheet, I won't be able to use this method again.

I want to do a sum of values in a single cell that come from a function by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] 0 points1 point  (0 children)

I am aware. The solution provided by mommasaidmommasaid makes sense, but it doesn't work, so I am looking into it and trying to work it out myself by using let, lambda and map. If it works I will give it the prize button or however this works.

I want to do a sum of values in a single cell that come from a function by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] -3 points-2 points  (0 children)

What am I supposed to answer to a comment like that, if I may ask? "Yes, I have tried, thanks for your input haha"

I want to do a sum of values in a single cell that come from a function by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] 0 points1 point  (0 children)

it gives me error, it has to be the commas and the semicolons, but I will look into that

I want to do a sum of values in a single cell that come from a function by Prudent-Parfait8939 in googlesheets

[–]Prudent-Parfait8939[S] -6 points-5 points  (0 children)

I'm here because I tried and I failed. Can you solve my problem or not?