This is designed to clear the adjacent cell to the right of the one that has just been edited – so long as it is within the column we specify.
It was developed as I was testing the available options for a Stock Inventory system where an item that was to be marked as back in stock would automatically clear an email timestamp in the adjacent cell (ready for the whole ordering process to start again).
Source: The Gift of Script: Clear cell content on Google Sheet edit
I use Google Apps Script to support staff and students in my job. I enjoy dabbling with creating tools to help with automation and I freely share my learning experiences on my blog, where I also have a number of useful Google Add-ons: www.pbainbridge.co.uk