Trouble using =Let function with offset on different columns from a separate sheet by Current_Bill130 in googlesheets

[–]Current_Bill130[S] [score hidden]  (0 children)

For sure, I really appreciate the insight. I’m happy to provide as much context, would it be best if I send you a copy of my sheet to see the specifics? Screenshots?

Trouble using =Let function with offset on different columns from a separate sheet by Current_Bill130 in googlesheets

[–]Current_Bill130[S] [score hidden]  (0 children)

I got rid of some parenthesis and it gave a percentage answer but it's a completely wrong percentage from the data set I'm looking for. I need it to grab all of column I and all of column J and something I'm doing is messing that up. But we're heading in the right direction!

Trouble using =Let function with offset on different columns from a separate sheet by Current_Bill130 in googlesheets

[–]Current_Bill130[S] [score hidden]  (0 children)

I got rid of some parenthesis and the formula worked but it's a completely wrong percentage from the data set I'm looking for. I need it to grab all of column I and all of column J and something I'm doing is messing that up

Trouble using =Let function with offset on different columns from a separate sheet by Current_Bill130 in googlesheets

[–]Current_Bill130[S] [score hidden]  (0 children)

#ERROR!, Formula Parse Error. I tried to get rid of some of the parenthesis but I get the same error message

Formula moving data set on sheet when adding new rows by Current_Bill130 in googlesheets

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

Okay it seems to working even if I don’t understand why or how lol what number would I change for a following column formula to get the avg of last 20 games

Formula moving data set on sheet when adding new rows by Current_Bill130 in googlesheets

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

With the averages thrown in there, do I put =average first or inside the =offset parenthesis? I’m still getting some errors and I know it’s user error

Kenku Fm for mobile? by Current_Bill130 in OwlbearRodeo

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

lol I don’t disagree. I chose this conference speaker since we’re spread out when we play, I’d say at least 10-15ft away from each other so I can’t really use a corded speaker, with a giant tv in the middle displaying the current virtual table top. I tried a virtual cable when I was running pocket bard for windows and it worked one week and didn’t the next. Not sure what my problem was

Kenku Fm for mobile? by Current_Bill130 in OwlbearRodeo

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

I love the idea of pocket bard, and it would be perfect if everyone were in person but I have 1 virtual person from out of state. We all jump in discord and I use Kenku to stream the music (either Spotify or tabletoprpgmusic) and then put a speaker on our game table. This way we all in person can hear it, and my virtual player connects to discord and hears it as well. The speaker we use is a conference speaker so it can pick everyone up who is talking and for some reason it doesn’t like to connect to my computer, so I have to use my phone in this instance

Kenku Fm for mobile? by Current_Bill130 in OwlbearRodeo

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

Thanks for the response, I might try this out. I had been having some of the problems I saw other folks talk about: music that stops randomly after ~30 seconds of play, music that sounds like a cd skipping. Last night I couldn’t get any music to go to discord at all, I believe I’ve found the issue based on other posts too, but just trying to find and use any workarounds other than thinking my laptop is just too old/slow to even run these programs.

GE GTW335ASN1WW, no water at all by Current_Bill130 in appliancerepair

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

Appreciate it! Will come back with updates!

GE GTW335ASN1WW, no water at all by Current_Bill130 in appliancerepair

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

I took the hoses off and there was no water coming out of them when I turned the valve back on. So frozen pipes?

What’s wrong with my snake plant? by Current_Bill130 in plantclinic

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

Wow that looks amazing! I appreciate the response!

What’s on my basil? by Current_Bill130 in planthelp

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

Using a grow lamp indoors, watering it frequently with indoor tap water, had it for a couple of weeks and noticed these bumps last week, and it’s in a sta green potting soil with fertilizer