This has less scripting than my other tutorials, but still shows a powerful use of math and one-time needs in the script. I’m creating a sales tracker intended for a call center where hours, calls, sales, and services would be tracked for each employee on read more
You can always run custom scripts and functions from the script editor, but sometimes it’s nice to have easier access. Here’s how to create a custom menu with custom functions in that menu.
When you simply Duplicate or Copy a sheet, the protections don’t come with it. Here’s how to copy a sheet while preserving protections.
Another 3 videos for you this time! Lock Cell After Edit Lock Entire Row After Edit Lock Row with Installable Trigger
Here are 3 video tutorials for moving an entire row of data based on some trigger. The first 2 use checkboxes, the last uses a dropdown menu. Move Entire Row with Checkbox Move Entire Row with Checkbox 2-way Move Entire Row with Dropdown
As a follow-up to my previous video showing how to setup 2-way data sync in a workbook, this shows how to setup data sync across different workbooks. The most important difference is that this setup uses an installable trigger rather than a simple trigger, and read more
This is a video tutorial for one of my most-requested setups: 2-way data sync. FILTER(), QUERY(), IMPORTRANGE(), and other methods can pull data from one tab or range to another, but they are all 1-way: source to destination. When you want to be able to read more
The Baptist Church, the Lutheran Church, the Catholic Church, The Church of Jesus Christ of Latter-day Saints, the church of the devil, the church of the [F]irstborn, the Church… The word “church” is often used to refer to either concrete or abstract entity: a building read more
Where: Vormir Who: Thanos, Gamora, and Red Skull Why: For Thanos to gain possession of the Soul Stone Did Thanos have some lore, some mysterious foreknowledge about the trial at hand to gain the Soul Stone, or was he just lucky to have with him read more
“It’s your duty,” “I am duty-bound,” “the Queen’s duties,” “the duties of the President,” “my duty to God,” “what are my duties?” A more basic question is, What is “duty?” Of course we can say “that which one is obliged to do” or “one’s responsibility,” but read more