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 values within a column
Can you count the number of repeat values with a column. For example--building a board roster and want to identify gender. Can I create a formula that counts how many females are in the column at the bottom of the last row of the column? Looking at the formula worksheet it is suggesting =COUNTIF(Female:Female, Female1). Get #BLOCKED or CIRCULAR REFERENCE.