Formula for counting values in Red

I have a conditional formatting in a sheet which colors Red if the due date is passed. Now i need a simple formula to populate all the values in Red in a Metric.

Any Help?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!