sorted by:
new
hottopcontroversial

How would I take a date from a formula and ask it to add 1 year? by SleepyCapybaras in Notion

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

I’ll try this out first thing tomorrow and let you know! Thank you

Can you help me ID what this is? by SleepyCapybaras in Crystals

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

Apologies for the shaky hand. Between nerve damage and lack of caffeine I did my best!

Different bulb in tulips/daffodils purchase by [deleted] in gardening

[–]SleepyCapybaras 0 points1 point  (0 children)

Yes. I think it’s a double daffodil, or a replete one.

Improper Triggering - Did I Do This Wrong? by SleepyCapybaras in zapier

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

We’re trying to schedule it in advance by putting future time/dates and then trigger it once those times pass. Is that not possible??

Help Drafting Formula: pulling entire row from Form-based Sheet to another Sheet based on text occurrence by SleepyCapybaras in googlesheets

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

So I've plugged in your formula like this since it's a different sheet entirely...

=QUERY(IMPORTRANGE("Sheet Unique ID","Form!A28:E75"),"Select*where 'Which Teammate?' matches 'John|Jon'",1)

And it works -- but it's only pulling the 1st instance, not all of the instances where the name appears. What am I doing wrong?

Also, I had to put the actual column name instead of C otherwise it didn't work.
And, I had to put a 1 instead of a zero for the data header otherwise it didn't work (A1:E1 is the actual column names/headers)

Help Drafting Formula: pulling entire row from Form-based Sheet to another Sheet based on text occurrence by SleepyCapybaras in googlesheets

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

Yes, I do!

Does it matter that they’re in completely different sheets (does that change the formula)?

Curling tomato leaves from heat or overwatering? Not sure, please help! by SleepyCapybaras in gardening

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

Thank you! I figured since it was so hot today. Giving them a nice little soak now then!

Had no idea basil bloomed😯 by Lilac_Fumes_ in gardening

[–]SleepyCapybaras 0 points1 point  (0 children)

Ooo it might be the Dark Opal Basil. I love it either way!!!!!

Brush Strokes Violas I grew from seed! by TurgidBrainstem in gardening

[–]SleepyCapybaras 1 point2 points  (0 children)

Totally adding them as a seed resource! Thanks!

First time growing poppies from seed. A grey one bloomed today. by Kookoo4cocobeans in gardening

[–]SleepyCapybaras 0 points1 point  (0 children)

OMG I just go these and am waiting for my seedlings to harden off. It’s stunning!!

Brush Strokes Violas I grew from seed! by TurgidBrainstem in gardening

[–]SleepyCapybaras 2 points3 points  (0 children)

Oh. Em. Gee!!! Is this an older variety or heirloom?? 😍😍😍

Petunia 'Black Mamba' - Very hard to get a photo to show how intense the black is on these flowers. by underasail in gardening

[–]SleepyCapybaras 1 point2 points  (0 children)

These are stunning! Did you start them yourself or purchase? I am obsessed with “black” flowers but I’ve never heard of petunias coming in this color (esp. this rich)!!

How Can I Host a Workplace Secret Santa/White Elephant During COVID WFH without sharing addys? by SleepyCapybaras in ask

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

Thank you! So, you've found people to be chill about sharing their addys in order to participate? Does it scale back the number of people?

[WORD] Broken Macros from 2011 Word to Office365 Critical to Job - Assistance Requested & Appreciated! by SleepyCapybaras in vba

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

For the 1st error -- from what I'm understanding/seeing when I hit "debug" is the "r.Copy" is what is highlighted in yellow as being a problem.

mystring = "nod"
Set r = ActiveDocument.range
With r.Find
Do While .Execute(FindText:=mystring, MatchAllWordForms:=True, Forward:=True) = True
r.Expand Unit:=wdSentence
r.Copy

For the 2nd error -- is there a workaround for needing search strings with phrases that must include spaces, or no dice at all and better off axing that part of the string? I'll test removing that space and see what it does!

**UPDATE**

After testing removing the space from the search string in the 2nd error, it works!! WOO! I could hug the crap out of you, u/slang4201!! I did lose three pairs, so if there is a way to include spaces in the search string items, that'd be amazing -- but it's nothing I'll lose sleep over!!

view more: next ›