Game Nights

Board Games

Participants

Played By (Regex)

replaceAll(replaceAll(prop("Played By"), "(\b\S+\b)(?=.*\1)", ""), ",", "\n")

Games Played (Regex)

replaceAll(replaceAll(prop("Games Played"), "(\b\S+\b)(?=.*\1)", ""), ",", "\n")

Note on Regex Patterns

These regex patterns only work the first time they're saved as extra \s are added that cause the formulas to fail the next time they're edited.

(\b\S+\b)(?=.*\1) becomes (\b\\S+\b)(?=.*\\1) → removing the extra \s before S and 1 allows the formulas to work again.