I have a dropdown status field and need to do a count of that field when the status is "Completed"

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • Answered
How do I create a formula field to count a drop down based on status. I have a Status drop down and need to count the number of times that field equals "Completed"

I keep getting a text = numeric operator error while trying to do an if statement
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 2 years ago

  • 1
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Make sure your formula field is a "formula-numeric" field.  

Then the formula should be:
If([Status]="Completed", 1, 0)