Use the SEARCH function to check if the guessed letter exists in the secret word.
Keywords: hangman google sheets, google sheets game template, classroom hangman, interactive spreadsheet, vocabulary game, apps script hangman. hangman google sheets
Assuming your secret word is in and your guessed letters are tracked in row 12 (we will build that next), use this array formula: Use the SEARCH function to check if the
: Use Data Validation (found in the Data menu) to create a drop-down list of letters (A-Z) so players can select their guesses. google sheets game template