In this article, I answer a question from the Smartsheet Community. A user wants to count rows that meet only certain criteria.
In the video below I’ll walk you through several methods you can use to count rows with logical formulas.
Methods used:
- Sheet Summary fields
- Sheet header row
- Cross-sheet formulas
Functions covered:
- COUNTIF()
- ISDATE()
- ISBLANK()
Resources:
- Try Smartsheet free for 30 days
- Want to work with us? Fill out our new client interest form
- Learn more about us here
