I have a spreadsheet that contains columns A through J of pre-existing data. I need to populate additional columns K, L, M which are current blank,with a new heading, and new data based on whether data exists in other columns. As an example:
For Column K - If a cell in Column A contains the words "New Work", then enter "Assigned" in the corresponding row in Column K. The first cell in Column K should be labeled State
I would repeat the same process for the other columns as needed, with other criteria.
I need this to be automated. I would require a script that I can make a scheduled task, and it will automatically enter this information.