COUNTIF or VLOOKUP capabilities?


Hello friends!

I have a column of data in a grid, formatted as a dropdown with specific text to select. I want to create a formula wherein each instance of a particular dropdown selection is counted-see generic example below. I've tried a couple of permutations of "COUNTIF" and VLOOKUP" to no avail. Is this something I should do in a report instead of the grid? Do I need a separate column in my grid for each status instead of a single drop-down?

Any advice would be appreciated.


I want to know the number of instances of each status: Full (5), Partial (4) and Canceled (1).

The grid contains hundreds, if not thousands of records. I'd like the totals for each status to update "automagically" when a new row is added or a status changes in an existing row (moving from "partial" to "full" for example).



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!