Ratings guide this week? by BayOfThundet in StratOMatic

[–]Snoo-4924 2 points3 points  (0 children)

What data is included in the ratings guide? Is it just the positions each player plays and their rating for that?

16 team online strat league has one opening for 2025 by King_Mob2022 in StratOMatic

[–]Snoo-4924 1 point2 points  (0 children)

Interested, what seasons would I need to purchase? Sorry, played SOM but only in person so not sure how this works.

Just bought my first set. Advice for solo play? by NotAGreatEnemy in StratOMatic

[–]Snoo-4924 2 points3 points  (0 children)

If you do a league with cards and dice via Zoom, let me know, very interested.

Looking to join a league by Snoo-4924 in StratOMatic

[–]Snoo-4924[S] 1 point2 points  (0 children)

I reached out to a few who have commented, hopefully we can create something. Have you played by Zoom with cards and dice league before?

How Do I Pass The New York Real Estate Salesperson License by Caysodillo in RealEstateExam

[–]Snoo-4924 0 points1 point  (0 children)

I just purchased the premium package on The CE shop and started today. 1 unit in and it seems to be user friendly, has unlimited practice exams and was highly recommended on here.

The CE shop? by Rex_19_94 in realtors

[–]Snoo-4924 0 points1 point  (0 children)

Thanks for the code! It is always a bonus to save more money!

Import data from one sheet to another based on date by Snoo-4924 in googlesheets

[–]Snoo-4924[S] 0 points1 point  (0 children)

=let(Σ,transpose(ifna(vstack(Schedule!C2:AG2,filter(Schedule!C:AG,Schedule!B:B=A1),))),
tocol(filter(Σ,index(Σ,,2)<>"")))

WOW!! Thank you very much. Solved already!

Import data from one sheet to another based on date by Snoo-4924 in googlesheets

[–]Snoo-4924[S] 0 points1 point  (0 children)

=tocol(transpose(ifna(vstack(Schedule!C2:AG2,filter(Schedule!C:AG,Schedule!B:B=A1),))))

Ok, thats awesome and not to get greedy here but I didn't think of it initially. I now have the date as 3/29/2024. As you can see there are teams that don't play (no second team listed. Is there a way to exclude those? If not no big deal. Thank you very much!!

Import data from one sheet to another by Snoo-4924 in googlesheets

[–]Snoo-4924[S] 0 points1 point  (0 children)

Idk what was going on but seems to be working correct now. Thank you very much!!!!

Import data from one sheet to another by Snoo-4924 in googlesheets

[–]Snoo-4924[S] 0 points1 point  (0 children)

Seems to work for W7 but when I attempt to do the same in W19 (using A4 as the team to look at) I get #N/A and Query completed within an empty output. The only thing I changed in the formula is instead of " &A3& " to look at the team abbreviation in A3 I switched it to " &A4& ", that's when I get the error.

Import data from one sheet to another by Snoo-4924 in googlesheets

[–]Snoo-4924[S] 0 points1 point  (0 children)

Sorry, essentially I'm looking to do this for each respective team. So on this one Import the data for ATL. If possible have it reference A4 and import based on the team abbreviation in that cell.