Sheet to sheet workflows
I want to link two sheets together by creating a new row in sheet 2 based on values in sheet 1. Example below:
Sheet 1 has either a multi-select column or several checkbox or yes/no columns (any works fine for my needs). The input in these columns tells the next team working on this project to perform these set of tasks. I want to track each task separately in sheet 2 as a new row and need to pull some data from sheet 1 (project name, selected tasks, user, etc) but not all of the data tracked in Sheet 1.
So the data would move like this:
I don't want to pre-populate sheet 2 with any data to search from. This would create more work for users - I'd like it to be as simple as when the user says yes or no in the task columns, sheet 2 will automatically add a new row with the appropriate info. Is this possible?
Thanks for the help!
Help Article Resources
Check out the Formula Handbook template!