Hello!
I have a master sheet where I keep track of all of our companies' giveaways we offer. It has a lot of checkbox columns to identify which tasks have been done and which have not. Currently I have automated reminders set up that send me an email to tell me something needs done. However, that A LOT of emails, and I have a task sheet that I would like to have these tasks feed into. Problem is, I don't want my giveaway sheet to have to use a helper column for each task. It's too many.
My solution (and please let me know if you come up with something else), is to have one line from the giveaway sheet feed into a helper sheet multiple times (once for each task), and assign a different task to each line as it arrives. THAT sheet will then be able to assign due dates to each line based on the task and feed into my complete task sheet. Clear as mud?
Giveaway sheet:
Example of the headers that are in part of the sheet. Each one has an automation that is based off of either the start or end date, depending on the task.
Helper sheet:
My thought was to have the rows copied to this sheet, and assign a task from the dropdown, for example: copied once and Crtv Apprv would be assigned, then the next line would be the same, except it would assign Media Upload, then the next line would also be the same, except it would assign Omeda Form, etc.
Task sheet:
I already have some of these fields pulling into my tasks and would do the same (adding "Task" as a column, or adding the task to a Details column so it aligned with the current set-up.
Question is: how do I accomplish this? I can do all the formulas to assign everything as needed, but feeding a single line into another sheet and assigning a specific value is just barely on the other side of my abilities.
I appreciate the help and any insight you may have.
