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 a value that appears within a row

Richard C
Richard C ✭✭
edited 12/09/19 in Archived 2017 Posts

I am building an inventory sheet for a nonprofit board and identified a number of criteria the board governance committee will need to track.  I've created various demographic columns such as age, ethnicity, residence, etc.  The formula below has worked for all the columns created so far but getting "unparseable" error.  I've checked the column property heading to make sure I have it right and I do.  Here is the formula that I'm trying to use.

=COUNTIF(Current Term Expire5, "2017")

Again, it is the same I've used for other columns which are working:

=COUNTIF(Age5, "45-64")

=COUNTIF(Ethnicity5, "Hispanic/Latino")

It appears where the formula works--the column header is highlighted and the header isn't highlighted in the cell that turns into unparseable.

Appreciate anyone helping out. 





This discussion has been closed.