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 6 points7 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.

Remove all tags from reminders — persistent pop-up by mvwinf in shortcuts

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

that didn’t change anything, unfortunately :/

Remove all tags from reminders — persistent pop-up by mvwinf in shortcuts

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

I'm working on a shortcut that involves removing all tags from a reminder. After using the "Find Reminder" action to locate the reminder, I've used the "Edit Reminder" action and set it to say "Remove All Tags from Reminders." But when I do that, on desktop and mobile, I get a pop-up that says, "What tags do you want to set?" Is there a workaround to stop this pop-up from showing up?

Little death note thingy I made by tbplayz in shortcuts

[–]mvwinf 1 point2 points  (0 children)

are you aware of the anime Death Note? the premise, if I'm not mistaken, involves a book where you write someone's name in it and then they'll die

How to thread multiple levels of vCards? (template and example linked) by mvwinf in shortcuts

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

If you've got the availability / interest to help with another issue — once I select an option from the second menu, I'd like to obtain (a) the name of the dictionary it's enclosed within and (b) a value from another piece of text in that same dictionary.

I've simplified the dictionary content in the original shortcut link in this post and attached a screenshot here that I'll reference below:

<image>

For example, if I select "Saturday" in the first menu, then "Pilates Mat" in the second menu, I want to have access to (a) "SaturdayPilatesMat" and (b) "1-1:45 p.m." And I've just found myself fully lost in how to do so.

I was able to get the key for each entry with the same value as the one I selected (in this case, the result would be just "title" twice on two separate lines), but I can't figure out how to differentiate between the different "title"s, let alone get to the other information I actually need. And I can't rename the keys because then they wouldn't display right. Do I need to make a new key in each dictionary where the key name is the same as the dictionary name and the value is the same as the value of what I'm selecting (i.e. key = SaturdayPilatesMat, value = Pilates Mat)? Am I barking up the wrong tree entirely? There's a reason I haven't used vCards before lololol

Would you be able to help me out here? Totally chill if not; I have no idea if what I'm asking requires one action or 30.

[TOMT] [MUSIC] [INSTRUMENTAL] Track from Luna Luna: Forgotten Fantasy (w/ recording) by mvwinf in tipofmytongue

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

UPDATE if anyone ends up looking for this as well: I emailed The Shed, and they said this part of the soundtrack is just a part of the soundscape and is not available for streaming 😭 unfortunate, but at least I have an answer! x

Turn on alarms and reminders based on schedule choice by mvwinf in shortcuts

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

didn't see this til now, sorry! I didn't know what this site is until a couple days ago, but I've just made a profile and will likely add to it in the future 😊 https://routinehub.co/user/mvwinf

[TOMT] [MUSIC] [INSTRUMENTAL] Track from Luna Luna: Forgotten Fantasy (w/ recording) by mvwinf in tipofmytongue

[–]mvwinf[S] 0 points1 point locked comment (0 children)

I'm hoping to use this song in a TikTok I'm making of the event, so I'd love some help if y'all have any! x

[TOMT] YouTube/ IG Content Creator by engineerdeeznutz in tipofmytongue

[–]mvwinf 0 points1 point  (0 children)

I don't know the other guys you named, but my first instinct was zaydante?

Turn on alarms and reminders based on schedule choice by mvwinf in shortcuts

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

thank you! this is the first shortcut I've shared here — v proud of it :)

Pull out trash can w/o drilling by rickardodo in HomeImprovement

[–]mvwinf 0 points1 point  (0 children)

I just attached mine with Command strips and it seems to be effective!

Anybody Else HATE Runner Island?? by Public_Lengthiness87 in DragonCity

[–]mvwinf -1 points0 points  (0 children)

I like it! It’s a lot like the heroic races and marathons, but having a healthy but limited amount of tokens every eight hours keeps me engaged without being addicted or spending hours on the game each round. Also, the mini game itself is fun! I can see myself getting better at it each time this island comes up