Google Sheets: Tips & Tricks

Will be amended as time goes by! 😄

Data Validation

1. Custom formula for uniqueness of values in a column with only text values:
   =EQ(COUNTUNIQUE(A:A), COUNTA(A:A))

Google AppsScript

1. Just learnt that if you define your JavaScript classes in one .GS script file, it has to be above the the other .GS script file if you want to inherit from any those classes in the other .GS script file. Awkward!