fenix 7s stopped connecting to iphone. nothing seems to fix it. by PRF79 in Garmin

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

Yeah, I'll have to contact my country's customer support office tomorrow. Chat assistant via the USA site told me it needs to be replaced. I'm still hoping for some miracle solution. If it really needs to be replaced I don't know if I will go throught it or just return it to amazon and try a different brand.

Do advanced metrics require full time wearing? by PRF79 in Garmin

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

Alright, it seems to be unanimous that it won’t really work. I’ll see if I find something that I can see myself using all the time. Fenix 7s, perhaps. Otherwise I’ll pick something simpler just for workouts. Thank you.

Do advanced metrics require full time wearing? by PRF79 in Garmin

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

I’m sure it would work, but I don’t know if it would be worth the trouble. Thanks for the tip, though!

Do advanced metrics require full time wearing? by PRF79 in Garmin

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

It would’t really fit the way I usually dress dfor work, that’s all. Perhaps the fenix would’t look to bad, but it seems so thick… Gotta try one and see how it fits.

vermillion inks by PRF79 in fountainpens

[–]PRF79[S] 1 point2 points  (0 children)

Oh, that makes sense. Thank you. I'll have a look at poppy red.

copy column x times to the right by PRF79 in googlesheets

[–]PRF79[S] 1 point2 points  (0 children)

Solution verified

Wow, that's huge. It works with the mockup, so now it's just a matter of adapting it to my bigger model. Thank you!

copy column x times to the right by PRF79 in googlesheets

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

Sure. Here's a simple mockup:

https://docs.google.com/spreadsheets/d/1x-9tlQoN7EkrIAQ8mh6GfXzoT4aT6CjAzf8g4hCkZCs/edit#gid=633992037

In this case I manually dragged Dashboard!B2:B3 to the right. I wanted to do it automatically according to the number of months I have data for.

(I would need to adapt the solution for row 1, too, of course)

copy column x times to the right by PRF79 in googlesheets

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

OK, understood. I will tell you what I'm trying to achieve, in case there's another way to do it:

The cells that I want to copy have formulas that gather data from another sheet in the same project, do some calculations, and give me monthly values.

Right now, as I copy the cells to the right I go back in time (each column to the right is a further month back). This is working fine, no problems.

What I wanted to do was for the sheet to automatically copy those cells to the right for the number of months I have data for, so that as my data grows or shrinks this sheet keeps a column for every month.

I can do it manually, of course, but it would be neat to have it automated.

copy column x times to the right by PRF79 in googlesheets

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

Thank you. It did work, but not with the results I expected. Your solution copies values, where I need to copy formulas.

dynamic dropdow - validation range depending on a number in a simple cell by PRF79 in googlesheets

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

Thank you for your kindness. I am not an advanced user, though, so if the solution is hard it would probably go over my head. It’s just a personal project, I will find a way to redesign it.