Summary Sheet Formula - counting live projects

Michelle Maas
Michelle Maas ✭✭✭✭
edited 05/18/21 in Formulas and Functions

We use a small project control sheet to manage all the small works that come into the business. I want to create a formula in the Summary Sheet to counts only live projects.

The top row header "Archive" is a PARENT for completed projects - I do not want to count these.

For any projects that have not been archived, the Finish column cell in the PARENT would indicate any live projects, i.e. < TODAY. I would like the formula to count these and any new additions to the sheet.

Another column that may be useful in this process is the Project Number.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!