Project Approval Received / Master Project Sheet Populated

Brad Huff
Brad Huff
edited 12/09/19 in Formulas and Functions

I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and budget info. This master sheet will also include automated workflows to alert the submitter of the new project to complete the charter and budget requirements (if new row created, fulfill... requirements). The idea is to have the master sheet feed all the necessary reports to be displayed within the top level dashboard(s). Is this possible? Thanks in advance for the feedback!

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!