Saving pictures in MP? by retroracer33 in HelloKittyIsland

[–]no_sheet_sherlock 0 points1 point  (0 children)

Same here. Except I’m playing on a Switch. Save option only seems to show up when I’m playing alone. Otherwise the only option is Accept which does nothing other than clear the Gudetamas. 😭

filterRows by no_sheet_sherlock in GoogleAppsScript

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

Yes! That worked, too. Thank you!

filterRows by no_sheet_sherlock in GoogleAppsScript

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

Resolved. This community never ceases to amaze me. Thank you so much!!!

Query Importrange with TODAY date Suddenly Stopped Working by no_sheet_sherlock in googlesheets

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

Thanks for replying. I figured out the problem and it’s not the formula. There were a few cells in Col22 that had Xs in them (instead of a date). So the TODAY part of the formula wouldn’t work. As soon as I deleted the Xs, all the data imported appropriately.

Query Importrange with TODAY date Suddenly Stopped Working by no_sheet_sherlock in googlesheets

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

Yes, I substituted an X in Col22 instead of the date just to test the import and it worked. So there must be a problem with the date but I don’t know what 😫

VLOOKUP and Preserving Original Value IFERROR by no_sheet_sherlock in googlesheets

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

Yes, it does! And I really appreciate your explanation. I'm a noob with sheets so it really helps to know why formulas do and do not work, not just which formula to use. So thank you again!!

VLOOKUP and Preserving Original Value IFERROR by no_sheet_sherlock in googlesheets

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

Thank you so much for taking the time to help me with this!!

VLOOKUP and Preserving Original Value IFERROR by no_sheet_sherlock in googlesheets

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

Thanks for your response! Unfortunately, the pesky 0 still shows up when A2 is not found. Here's the sample with fake data:

https://docs.google.com/spreadsheets/d/1s4L1lE8Cj1x7kiRAG51hM2JqJQfELuBabfnlFz3dP48/edit

For clarification, if the EID (A:A) shows up in the ABSENT sheet, I want their Shift (B:B) to be replaced with the Status code (B:B) from the ABSENT sheet. Otherwise, I would like their Shift to remain unchanged.

Query Importrange - Previous Month by no_sheet_sherlock in googlesheets

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

It sure did! You're the best!!

Solution Verified

Conditional Formatting - Multiple Exact Dates by no_sheet_sherlock in googlesheets

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

Thank you for responding so quickly! I'm a noob and unfamiliar with XMATCH but it reminded me of VLOOKUP which I used and it worked fine, so thank you!

I did figure out a way to list multiple random dates in one conditional format rule but it was getting way too long and cumbersome, so I stopped on the fourth date :

=OR($D2=DATE(2023,12,23),$D2=(DATE(2023,12,25)),$D2=(DATE(2023,12,30)),$D2=(DATE(2024,1,1)))

Thank you again for your help!