Is there an alternative to =SUBTOTAL in Smartsheet

Hi Guys,

Trying to to find a formula that will allow me to sum a row based on the filter that I have setup on the sheet. I've included a screen shot of the filters I have on the sheet as an example.

I have created a summary formula to count the column but I need this to change count based on the filter options I choose.

Any suggestions?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!