Excluding two values for Sheet Summary Formula

Hi all,

I was wondering whether you might be able to help. I have a column "Status" and I would like to write a formula for a sheet summary field that counts the number of status' that are anything other than "On Hold" and "Complete".

I've tried various COUNTIFs but none seem to be working! Any help on this would be great!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!