Count the number of times a value shows up in a column

For whatever reason, I cannot find the right syntax to create a formula that works to count the values in a given column. I'm trying to use it for a sheet summary.

I've been trying variations of this: =COUNT([Quote Validation Step]:[Quote Validation Step], [Denied])

I get #UNPARSEABLE

Best Answer

  • darrink
    darrink ✭✭✭✭
    edited 04/29/22 Answer ✓

    Nevermind... I figured it out. Rookie mistake...

    Here's the correct syntax: =COUNTIF([Quote Validation Step]:[Quote Validation Step], "Denied")

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!