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.

Formula Help - Track Quantities

I have a metrics grid that pulls in totals from another sheet. The goal of the sheet is to track the quantity of a particular project we are working on. I am using a column that tracks status to determine where the project is.

Currently I have the top row that shows the total # of projects and the formula there is: =COUNTIF({Page Status}, "Quarter")

The next row is counting how many are in the next status. What I would like to do is now subtract from that first row, so by the time it goes to a row labeled "Full" or "Complete" the other rows are showing 0.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions