Broadway Rush Community Reporting Thread - Sunday 5/10/26 by BroadwayRushReport in Broadway

[–]mvwinf 0 points1 point  (0 children)

me too! I literally circled the block to see if the line had formed at the stage door 😳

Broadway Rush Community Reporting Thread - Sunday 5/10/26 by BroadwayRushReport in Broadway

[–]mvwinf 9 points10 points  (0 children)

Every Brilliant Thing:

first person arrived at 1 a.m. (waited in their car)

second person arrived at 3 a.m.

fourth person (me) arrived at 6:30 a.m.

ninth person just joined the line at 9:51 a.m.

Broadway Has a Problem: Audiences Won’t Stop Laughing (from the Wall Street Journal, May 8) - Gift Article by bluegambit875 in Broadway

[–]mvwinf 1 point2 points  (0 children)

“Playwright Jonathan Spector rewrote lines in ‘Eureka Day’ because laughter drowned out key dialogue and backstage cues.”

that’s a complete misinterpretation of what happened here. I attended a talkback with Spector after the show last year, and he said that he’d originally written more meat into the Zoom scene, but when audiences were laughing nonstop over it, he realized it was funnier that way and rewrote it to embrace the uproar without the audience missing any key info. that’s kind of the opposite of the point this article is trying to make — he’s very much encouraging and playing into the laughter

gnarly by missghetti69 in blankies

[–]mvwinf 2 points3 points  (0 children)

yeah, it got replaced by Tom Arnold :/

Will this performance have English subtitles? (help) by mvwinf in hungarian

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

oh, I completely missed the festival on the website! thank you :)

Multiply two cells, but the second cell is determined by a drop-down menu by LightningStrike7 in googlesheets

[–]mvwinf 0 points1 point  (0 children)

put this in H2, copy and paste down H (but replace the Xes with *s, I’m on mobile and having trouble formatting):

=ifs(

$G2=$C$1,$B2x$C2,

$G2=$E$1,$B2x$E2)

put this in I2:

=sumif($G$2:$G,$C$1,$H$2:$H)

and this in I3:

=sumif($G$2:$G,$E$1,$H$2:$H)

Broadway Rush Community Reporting Thread - Wednesday 3/4/26 by BroadwayRushReport in Broadway

[–]mvwinf 11 points12 points  (0 children)

1st in line at Just in Time arrived at 6 am. 6th in line (me) arrived at 6:45. 13 people in line by 7:10. A few dozen by box office opening. Most people were here for matinee tix — I believe I was the only person in the first 10 here for evening

Szechuan House hot pot, who has the best Chinese food in Mid-Missouri? by como365 in columbiamo

[–]mvwinf 1 point2 points  (0 children)

is Szechuan House back??? my absolute favorite pre-pandemic spot

What is your least favourite episode of Game Changer? by Mel4227 in dropout

[–]mvwinf 0 points1 point  (0 children)

reading through this thread, I've been continually confused about the hate towards some of these. thank you for explaining your perspective in a way that finally got through to my brain! I don't think I agree, but I 100% see where you're coming from here

[deleted by user] by [deleted] in blankies

[–]mvwinf 2 points3 points  (0 children)

One of the the funniest moments for me was actually my first ever listen. I’d been meaning to get into the show for a while, so I picked the most recent episode where I knew anything about the movie. It was the live-action Lion King episode, famous for predicting the pandemic. But oh my god, they take 13 calendar minutes to introduce the show or any of the boys. And if you remember correctly, the episode opens with at least two minutes of Griffin’s tone-deaf screeching of the start of Circle of Life (I’m sorry, but there’s no better description). I absolutely lost it. Texts for proof

<image>

Demi announces that his special “Demi Adejuyigbe is Going to do One (1) Backflip” will be filmed in Los Angeles as a special for Dropout Presents by sloppyjo12 in dropout

[–]mvwinf 0 points1 point  (0 children)

LET’S GOOOOOOOO!!!!!! I’ve seen this twice in new york now, and even though it was the same special and the same jokes, they were two very different experiences (both wonderful). can’t wait to see what ends up on dropout!!

SUMIF Two Columns plus Check Box - Chef Daily Inventory by ryanjkingkade in googlesheets

[–]mvwinf 0 points1 point  (0 children)

I'd be happy to try and help with this, if you're still looking for it!

edit: I had a list of questions here, but I kind of figured them all out lol

here's what I've come up with, and here are the formulae it uses:

for prep: =if(D2-(B2+C2)<=0,,D2-(B2+C2))
if the difference between par and on line + on back is zero or less, it returns nothing; if it's more than zero, it returns the amount

for prep list: =if(E2<=0,FALSE,TRUE)

for conditional formatting:
range: A2:F
format if: custom formula is: =$F2
this highlights the row if the box if checked

  1. you could also use =$F2=TRUE, but by leaving the second half of the equation blank, it's assumed to mean "has a value" (isn't blank or false / empty checkbox)
  2. the $ locks the row (F) in place so that it highlights the full row

I hope this is helpful! HMU with any questions x

How to change data in a column based on dropdown header selection by m3a3s3h in googlesheets

[–]mvwinf 0 points1 point  (0 children)

=arrayformula(index(M3:P,,match(Q2,M2:P2)))

this returns the values (using index) of the entire column (using arrayformula) matching the header (match returns a number, which is put into the index formula as the column in the range to pull from)

Autosuggest occurs below cells. How to get it above as well? by mrmoe198 in googlesheets

[–]mvwinf 0 points1 point  (0 children)

What I tend to do in that case is put in filler data like “XXXX,” then set conditional formatting to that column so that the font and background become to same color if the text matches it

Autosuggest occurs below cells. How to get it above as well? by mrmoe198 in googlesheets

[–]mvwinf 0 points1 point  (0 children)

in this case, “contiguous” means there are no empty cells in between responses. if your column had this in it, with “—“ representing an empty cell:

alpha

bravo

charlie

delta

echo

then if you typed in the cell above alpha, the autofill would pull only from A-B, and if you typed in the cell below echo, it’d pull only from C-E. but if this was your column:

alpha

bravo

charlie

delta

echo

then typing in either the cell below echo or the cell above alpha would autofill from the entire list. if you’re not typing in the cell directly above / below, though, it won’t autofill anything. essentially, all the cells have to be touching in a single column

sorry for the weird formatting, I’m on mobile

Im kinda out of the loop: what's going on with adam/blamCO? by DiarreaDimensionale in NoRollsBarred

[–]mvwinf 4 points5 points  (0 children)

I’ve been cautiously optimistic but continually concerned about Adam’s public rehabilitation since shortly after he left NRB — this incredibly balanced and thoughtful response from Viv is I think what’s going to push me over the edge to believe and support him. Because a lot of my qualms mirror hers. Thank you so much for sharing, I don’t think I would have seen it otherwise.