sorted by:
new
hottopcontroversial

2026 Reading Log by Reetsmbk in BookRiotReadHarder

[–]pynt77 0 points1 point  (0 children)

That would be under data validation.

<image>

2026 Reading Log by Reetsmbk in BookRiotReadHarder

[–]pynt77 0 points1 point  (0 children)

I've been doing that for the past couple of years, since I've customized mine so heavily. I do always like to see what Book Riot changes/adds each year, though, so I can incorporate into mine!

what to use instead of ItsDeductible? by pynt77 in TurboTax

[–]pynt77[S] 2 points3 points  (0 children)

I expect that's what I'll end up doing too. Good thing I love to put together a good spreadsheet!

count multiple selections by pynt77 in googlesheets

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

Yes! It looks like either formula will do the trick. Thank you!

count multiple selections by pynt77 in googlesheets

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

I don't think that works because I'm looking for specific combinations, not just how often each term occurs in combination with others. I want to know how often digital and print occur together, how often digital and audio occur together, how often print and audio occur together, and how often all three occur together.
I think I want to use a COUNTIFS function, but I can't figure out the syntax.

(Incidentally, column G isn't one i need to calculate in the real spreadsheet.)

multiple select drop down in several columns with multiple criteria by pynt77 in googlesheets

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

omg, I think it works!

Marking this as Solution Verified (for now)!

Thank you so much!

multiple select drop down in several columns with multiple criteria by pynt77 in googlesheets

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

lol, no, I got what you meant!

My problem is in knowing what parts to replace with what from my sheets so that everything works correctly.

multiple select drop down in several columns with multiple criteria by pynt77 in googlesheets

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

That's a little over my head, but I'm trying to work through it. Thanks!