Google Sheets CRM System - UPDATE
This video covers the changes I've made to the CRM system I demonstrated in my earlier videos since uploading them, including a script to automatically transpose data from a single-sheet data range to procedurally generated sheets.
If you aren't familiar with the previous videos on this subject, they can be found here:
Creating a CRM System in Google Sheets 1 - Overview and Demo
• Creating a CRM System in Google Sheets 1 -...
Creating a CRM System in Google Sheets 2 - Data Validation, Vlookup, and Protected Ranges
• Creating a CRM System in Google Sheets 2 -...
Creating a CRM System in Google Sheets 3 - Conditional Formatting, Drawings, and Javascript
• Creating a CRM System in Google Sheets 3 -...
Creating a CRM System in Google Sheets 4 - Limitations and Conclusion
• Creating a CRM System in Google Sheets 4 ...
And to make use of the template sheet and javascript code yourself, you can find them here:
Google Sheets Clone Sheets Script
https://pastebin.com/3CMKLrih
Google Sheets Navigation Clearform Script
https://pastebin.com/HkihzFq9
Google Sheets CRM Template
https://docs.google.com/spreadsheets/...