simple COUNTIF Sheet Summery formula


need help with this simple formula for a sheet summary

=COUNTIF([IEP Status], "NEW (not signed)", "Active", "Active (Needs Att.)")

something is wrong with the formatting I want to count number rows that contain these specific drop down list values. I put the values in quotes but the parentheses from the drop down values are turning pink which I think means they are registering as part of the formula. do i need to remove the parentheses from my drop down values for this to work right?

thanks much!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!