Can selections from a list be added to each row under a job based on job criteria?

I am not thinking this is a possibility, but thought I'd ask in case I missed something. Can a list of tasks be populated in the rows under a new job row based on criteria in a different row? For instance, I have a column for project type and a column for project tasks. If Sign is selected as the project type, can Smartsheet's (using either formulas or another function) automatically populate the next 3 rows with the tasks: Base build, version build and base file release. Each in a separate row? I don't think it's possible, but thought I'd ask....

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!