Open AlfredNwolisa opened 1 month ago
This script is to test the functionality to be integrated in the new form sheet alenssandro is working on. For now its being tested on the current form sheet here https://docs.google.com/spreadsheets/d/1Q96KDppKsn2khdrkraZCQ7T_qRSfwj7WsvqXvuMt4Bc/edit?gid=2061813733#gid=2061813733
feat: Add Script function to copy and clean data with date updates for "" sheet
combinedScript
function to streamline data handling.copyDataToCleanedTab
function to allow users to copy specified rows from the "Raw data" sheet to the "[CLEANED] For import" sheet. The function allows for user input of the row range and supports copying of selected columns.updateDatesBasedOnColumnC
function to automatically update dates in column B based on non-empty cells in column C.