COUNT Function

Counts nonblank values
Sample Usage
COUNT([Task Name]1:[Task Name]5)
  • value1
  • [
    • value2
    • ...
  • value1
    The value, typically a cell or range of cells, to count
    • value2
    • ...
    Additional values or ranges to count

This example references the following sheet information:

  Clothing Item Item Number Units Sold Status
1 parent row expanded icon Totals C000 337 Red
2       T-Shirt C001 78 Green
3       Pants C002 42 Red
4       Jacket C003 217 Yellow

Given the table above, here are some examples of using COUNT in a sheet:

Formula Description Result
=COUNT([Units Sold]:[Units Sold]) Counts any field in the Units Sold column that contains a value. 3
=COUNT(CHILDREN([Item Number]1) Counts any field that contains a value and is the child row 1 in the "Item Number column. 3
=IF(COUNT(CHILDREN(Status1)) = COUNTIF(CHILDREN(Status1), "Green"), "Status Green", "Status Not Green") Returns Green if the count of the child rows in the Status column is equal to the count of the child rows in the Status column that also contain Green. Otherwise, the function returns Red. Red

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community