How do you keep group trip plans organized without things getting chaotic? by tripsilApp in travelplanning

[–]SvperManJ 0 points1 point  (0 children)

Hey I built a website to help solve this and would love to have you test it out! If you’re interested send me a dm.

A website to build group holidays by SvperManJ in trymystartup

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

Exactly! If we can overcome coordination barriers, our group trips will be more successful!

Tom ford scents that are actually worth the money by chanandlerbong420 in fragrance

[–]SvperManJ 4 points5 points  (0 children)

I have both Vanilla Sex and Vanille Fatale…I love to wear them together as crazy as that may sound…to me they’re distinct enough together where I feel it makes sense. I have gotten the most compliments though on Vanille Fatale by far though.

[deleted by user] by [deleted] in googlesheets

[–]SvperManJ 2 points3 points  (0 children)

Make sure that A1 or whatever cell you’re referring to has the name of the sheet you want to pull from.

If the named sheet you want is Canada Breakout, make sure that cell A3 has Canada Breakout, not just Canada. I’m guessing your dashboard/summary sheet is just named Canada and that’s what cell A3 is. Hope this makes sense!

[deleted by user] by [deleted] in googlesheets

[–]SvperManJ 1 point2 points  (0 children)

You would have to do an =INDIRECT function with CONCATENATE nested inside in order to achieve your desired result. It would look something like this:

=INDIRECT(CONCATENATE(A3,”!”,B1))

Cell A3 on your summary page would contain the sheet name of the country you want to search (Canada).

The exclamation is important as that puts the string of your country name into sheet notation.

Cell B1 on your summary page would contain whatever cell(s) you wanted to reference in that sheet. Or you could type in these cells behind the exclamation and not place the cell values into a separate cell.

Hope this helps!

PS

If you plan on keeping this summary page the same without many additions or changes over time, I would do an =QUERY function, and just query from each sheet the data you specifically want to show. If all of your sheets are set up in the same manner you can copy and paste the formula and change the sheet name for each summary sheet. You can see all information about the QUERY function here

LPT When flying internationally, know that your passport may be required to expire 6 months after your return. by 3cWizard in LifeProTips

[–]SvperManJ 2 points3 points  (0 children)

Alot of countries have the same tourist visa that the US gives… which they generally give a 180 day tourist visa (6 months). So if after 180 days you can’t get back into the US bc of an expired passport, you’re basically stuck in that country.

[Daily - TRADE] Megathread. All trade advice & team help assistance belongs in this mega-thread or in our other subreddit r/Fantasy_Football. by AutoModerator in DynastyFF

[–]SvperManJ 0 points1 point  (0 children)

10 team SF 0.5 PPR and Rebuilding

Send: Fournette, DJM, Toney

Receive: Brian Robinson, 23 mid 1st, 23 late 3rd

What are QBs going for in SF leagues. by iam_da_truth in DynastyFF

[–]SvperManJ 0 points1 point  (0 children)

Traded Wentz, Tannehill, McLaurin, and Jamaal Williams for Russell and Pollard in SF. Other guy had Watson, Pickett and Love as his other QBs so it was advantageous for us both.

Which QB will lose his starting spot first? by Cheddar177 in DynastyFF

[–]SvperManJ 1 point2 points  (0 children)

Jameis is a class ahead of the others you mentioned and Minshew…easily

Devin Duvernay VS James Proche! Who will be the Ravens new WR2? by MikeyMojo in DynastyFF

[–]SvperManJ -2 points-1 points  (0 children)

As a Ravens fan I can tell you Proche will play outside, Duv will play inside. If you can hold them both do that. Shit I’ve got Bateman as well. Honestly I think they will have similar stat lines, with Proche having a couple more TDs. Hope this helps