i have the below formula to count "VCD" in a Column

=SUM(COUNTIFS({Hubgrade Status Range 1}, HAS(@cell, "VCD")))

I want it to also check another column and give me back the result if that is blank. Is this possible to do?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!