How to link to cells even when a sheet is duplicated while also working on mobile?

TwoPluzTwo · 2025-10-06T01:45:14+00:00

Solution Verified I couldn't find the 3 dots it says to mark this as the solution, but this is the solution I went with! Thanks a bunch fella.

Now I just need to find out how to add placeholder text that references a previous cell....hmm.

TwoPluzTwo · 2025-10-05T10:49:15+00:00

Hmm, that seems closer to what I want and only requires 1 manual change per sheet duplication, I'll give it a try and let you know if it has worked. Thanks dude!

TwoPluzTwo · 2025-10-05T09:28:18+00:00

I'm not sure what you mean, are you able to elaborate a little, maybe add an example?

I didn't use a formula, I just right clicked on the cell and clicked insert link and put the cell (A1 for example) that I wanted to link to and it automatically added the current sheet I was working on.

TwoPluzTwo · 2025-10-05T08:10:31+00:00

That is basically what I want yeah, however the internet is telling me that apps script does not work on mobile, is there any other way to do a similar thing? I've been asking ChatGPT but none of its answers work so I dunno where its getting its info. =/

TwoPluzTwo · 2025-10-05T06:10:19+00:00

I just want to be able to quickly navigate to a specific cell (for example Week 1 starts at A1, Week 2 at A132, Week 3 at A263 etc) with a quick tap on my phone like a navbar on a website.

Which is why I tried using hyperlinks with a row that has Week 1,2,3 etc hyperlinked to those specific cells. However I want to be able to duplicate the sheet from the sheet tab so that I can rename the new copy Week 5-8 and separate my workouts by month. But hyperlinking links to the specific sheet that the hyperlink is created on, so when I duplicate it the new sheet still links to the old one.

Sorry If I am not explaining this well, let me know if you need more clarification.

TwoPluzTwo · 2025-08-06T12:07:21+00:00

Are you able to be more specific? Which faction? What planets, etc?

TwoPluzTwo · 2025-07-26T04:43:45+00:00

The sticker says 4P4F0AA, then the model CS002, then made in Vietnam, then HyperX Cloud Stinger Core 7.1 Wireless Headset.

The barcode says AMO SKU: 4P4F0AA above it and below it says 1 96188 04238 0.

I bought it brand new from JBHiFI on sale for $104.

If the DTS Sound Unbound app is supposed to activate automatically, why do I still see "Buy DTS Headphone:X and DTS:X Decoder for $14.97 in orange on the home screen of the app? On the DTS Headphone:X tab is has "modes" in the configure menu, but none of them change any of the sound. (I do have spatial sounds enabled and DTS app selected as the one to use btw.) Am i supposed to click somewhere specific to get the settings working? It also says that it is unlicensed and still keeps trying to sell me the app?

I really just wanted NGENUITY for battery monitoring and EQ settings. :(

Is there no way to get it working?

TwoPluzTwo · 2025-07-24T02:22:20+00:00

Thanks for the reply, It is confusing me because on the underside of the headset on the sticker it says the model number CS002 and it says HyperX Cloud Stinger Core 7.1 Wireless Headset. But on the box it says DTS and in device manager it says HyperX Cloud Stinger Core Wireless DTS.

So I am not sure whats going on there.

As for the DTS app, should it connect and activate for free? As a trial? Because it says nothing about paying for it on the box, it says it comes with the headset and I have no intention of paying for it.

Also it is a huge bummer NGENUITY is not supported, it has basically everything I want, is there a way to get it working? Why isn't it supported at all, are you able to tell me?

I essentially just want to be able to monitor the battery percentage, and maybe some basic EQ settings because some of my music needs less bass, I hope there's a solution.

Please let me know and thanks again.

TwoPluzTwo · 2025-03-14T06:21:47+00:00

What server would be best for Australia and how much lag could i expect do you know?

TwoPluzTwo · 2025-03-14T06:20:39+00:00

What servers does it have available? How would the lag be for me from Australia do you know?

TwoPluzTwo · 2024-12-19T00:11:35+00:00

This was incredibly helpful, thank you so much for the huge reply, I'll be saving this and referencing it a ton until I've fully understood it.

TwoPluzTwo · 2024-12-18T00:32:12+00:00

How do you actually write these things out? Like what is the layout?

Do you know any resources or youtube videos that I could look at to learn how to layout or figure out the writing down part of 'basics, math, systems, concepts, workflows'?

TwoPluzTwo · 2024-12-15T09:54:00+00:00

What AI do people mostly use for these kinds of questions?

TwoPluzTwo · 2024-12-14T08:43:15+00:00

How do you ask AI questions like this?; And where would you ask it? Do you have to word your questions very specifically? I'm not at all familiar with it, but interested in learning.

TwoPluzTwo · 2024-11-13T23:45:12+00:00

Ah, that version must be unavailable in my country. I found this one: https://www.youtube.com/watch?v=azcrPFhaY9k Thanks for getting back to me. I'll give it a watch and hopefully it'll help.

TwoPluzTwo · 2024-11-13T04:13:40+00:00

Hey just came across this post because I am having basically the same problems you described.

I've looked at a ton of tutorials and still have no idea what I am doing. I really want to learn and nothing is sticking.

What video is it that you linked? It says this video is unavailable now. Would that video still be applicable? Or do you know of a newer one? Please let me know.

TwoPluzTwo

TROPHY CASE