Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Project Approval Received / Master Project Sheet Populated

✭✭
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!

Trending in Formulas and Functions