https://docs.google.com/spreadsheets...it?usp=sharing
I have the above Google Sheet that I would like "tidy" up a little if possible to make it more usable.
If say Judge 1 AND Judge 2 do not enter any scores then I'd like column G to have the text in the relevant cell as "Awaiting Average", column H to have the text in the relevant cell as "Awaiting Sores" and column I to have the text in the relevant cell as "Did Not Compete".
Is this possible to achieve with Google Sheets?
Any suggestions or assistance would be greatly appreciated.
Many thanks.
Stewie.
Bookmarks