Create a Many to Many Database inside Google Sheets

[@1lllllllll1]

This is great for tagging, that’s exactly what airtable solved nicely in their UI, and I’m very happy you covered this topic.

[@BetterSheets]

And dropdown chips, I think, were google's answer to airtable.

[@pierreg2780]

This will be perfect for my loot table/encounter table for Dnd! Thank!

[@BetterSheets]

Amazing!

[@MarceloMaidanaAU]

This is great! Thanks for that, now, here is another challenge, how can you filter the name table by keywords that have CEO on it?

[@BetterSheets]

use FILTER() function

[@mooripo]

That's beautiful ! Thnk you

[@BetterSheets]

Glad you liked it.

[@MarceloMaidanaAU]

This is great! Here is another challenge, how do you now filter your name tables by all the keywords that have CEO on it?

[@BetterSheets]

use FILTER() or SEARCH() inside of a FILTER()

[@edison.villamor]

Can you put this formula inside an arrayformula? that way we don't have to copy paste all of them until the last row? Or is there any other way to achieve this? Just wanted to do it all in once cell.

[@BetterSheets]

Not that I can tell. Array Formula doesn't work on filter for this.

[@agoogleuser6937]

Magic!!

[@BetterSheets]

Abracadabera