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

 

J. Craig Williams

Also, this formula should work:

=COUNTIFS(DateA:DateA, NOT(ISBLANK(@cell)), DateB:DateB, ISBLANK(@cell)) + COUNTIFS(DateB:DateB, NOT(ISBLANK(@cell)), DateA:DateA, ISBLANK(@cell))

There might be a shorter way, but my coffee has not kicked in yet.

This is what is known as an "exclusive OR". Smartsheet does not have that function yet.

Craig