Count Formula Help


I need a formula that will count the # of times a task is in a specific status. The goal: Formula can tell me 6 tasks are in In Progress.

Example (see screenshots).

  1. Project Plan - Observe AI: Status column

2. Test Sheet: Would I use a countif formula? If so what would the rest look like to calculate?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!