Counting the value from one column only if it is in the future

Hi All,

I have 2 columns, one with Fuel systems, and another with the dates they have or will be delivered.

Looking at the snap shot below, what formula would I use to only count the entries of the fuel system column that contain "AGILITY" and that have a Del Date in the future?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!