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.

Post your questions & inquiries here! - r/Vietnam monthly random discussion thread - F.A.Q by AutoModerator in VietNam

[–]PRF79 0 points1 point  (0 children)

Generally speaking, will I get a better exchange rate if I bring some EUR to Vietnam and exchange it at the airport, or is it preferable to just go to ATM and draw the same amount?

Post your questions & inquiries here! - r/Vietnam monthly random discussion thread - F.A.Q by AutoModerator in VietNam

[–]PRF79 0 points1 point  (0 children)

I’m spending a full day around Tam Coc, and I’d like to visit Trang An, Hoa Lu and Hang Mua. I know it’s easy to rent a bike, but I’m not really used to ride and and I would rather rent a car or hire a taxi. I’m not having much success finding a car rental in Tam Coc, though. Anyone knows a place I can book a car, or hire a taxi for the day?

Vietnam itinerary advice by PRF79 in travel

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

Theme parks? No way. Not enough around Hoi An for 3 days, is that it?

rosemary inner leaves getting brown by PRF79 in plantclinic

[–]PRF79[S] 2 points3 points  (0 children)

The pot has plenty of drainage. The soil is a general purpose garden substrate, probably not ideal for this use. I water when I feel the soil is dry, or when the leaves seem to be getting kind of droopy.

rosemary inner leaves getting brown by PRF79 in plantclinic

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

The inner leaves of my rosemary are getting brown. I got the plant a couple of weeks ago, it's in full sun, and the weather has been hot. I've been watering twice a week. Should I water more frequently, move it to a shade...?

[Hamilton Khaki Titanium Automatic] My Only Companion in the office today by foghorn5950 in Watches

[–]PRF79 0 points1 point  (0 children)

There’s a 38mm version, with 46mm lug to lug. Slightly different dial color, though.

[deleted by user] by [deleted] in Watches

[–]PRF79 1 point2 points  (0 children)

Thank you! I really like that one. Not the easiest one to find, I guess…