Counting results of formula

Mikael Gustafsson

Hi,

 

I have a sheet with two date columns. I want to count the rows where only one of the date columns have a value. I´ve tried to create a third column with a formula that sets it to 0 or 1 depending on whether the second date column ISBLANK. It works but a cant count the zero's or one's since it seems smartsheet cant count the result of a formula in a cell. Any ideas on how to do this better?

 

Thanks!

 

Mikael

J. Craig Williams

If your count formula is in a Checkbox type column, convert it to text like this

 

=YOUR_FORMULA + ""

for example

=COUNT([Date]:[Date]) + ""

If you need to use that number in a calculation somewhere else, use VALUE() in the formula referencing it.

Craig