Sheet to sheet workflows

Options

Hi,

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!

Ryan

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!