Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Counting rows with multiple drop-down options
I would like to count all the rows on a sheet that meets certain criteria. The sheet has a column [Project Status] with the following drop down items:
I would like to get a total count of all the rows that have open projects, which would be one of the these statuses:
Please advise on how to make this formula work. Thanks!