Skip to content
Under the hood

Formulas

Formulas and buttons here power the magic behind the scenes! Keep this section hidden and/or read-only - you shouldn't need to make any changes here.

GamePlayStatement:
@Hannah Rochau
touched
@ENGLAND
and guessed incorrectly.
@ENGLAND
is
@Neutral
. It is now the
@Blue
team's turn.
This formula helps navigate the game by stating what's happened during game play.
Who'sTurn:
@Blue
This formula returns the current team's turn.
PlayerRole:
You are on the team. Wait for the spymaster to give instructions!
This formula returns the assigned role of the current logged-in user.
Formulas for setting up the board

RandomWord:
FIREPLACE
Pulls a random word from the word bank.
Position:
Pulls a random position to assign the word to.
Add cards to board
This button sets up the board for game play.
Reset the board
This button clears the currently selected cards and the event log by pushing the three buttons below.
Wipe board
Wipe board 2
Clear event log
Randomize Teams



RunActions(ModifyRows([Words in play].Filter([Row ID]=17),[Words in play].[Word Type],If([Words in play].Filter([Row ID]=17).[Word Type]=Red,Blue,Red)),[Words in play].[Press both buttons],AddRow([All events],[Spymaster view].[Date/Time],Now(),[Spymaster view].Event,"created the board.",[Spymaster view].Turn,1,[Spymaster view].User,user(),[Spymaster view].[Team Turn],[Turn Counter].Filter([Goes first?]=true)))

0

[  ]

12345678910111213141516171819202122232425
21617725244161013238199513214201118221512

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.