Google Sheet Automation and Script

Scenario:We run a content marketing agency. I have a Google Spreadsheet which we use to track which clients have submitted content to us. Columns represent clients and rows represent weeks.When click Scenario:We run a content marketing agency. I have a Google Spreadsheet which we use to track which clients have submitted content to us. Columns represent clients and rows represent weeks.When click A submits content for this week, we input some basic details into the cell.When content is not entered into a cell for the next we...