This code allow you to set data validation rules which depend on cell values. Depth of rule is not limited.
- Copy content of
./build/*.js
folder to your Google Sheet App script. - Change file extension from
*.js
to*.gs
- Edit
1.Code.gs
file to configure for you desire.
npm install -g @google/clasp
- Login to Clasp and give required permissions
clasp login
- Install Typescript
npm i -S @types/google-apps-script
- Fork and clone this repository
- Configure your
scriptId
androotDir
in.clasp.json
file. - Install node modules
npm install --dev
- After making changes compile
src/*.ts
files to folderbuild/
with command
tsc --watch
- Push changes to your Google Sheet
clasp push -w
- Link to Spreadsheet