Either / Or but not both

Nick Randall

Hi 

Could someone help please?

I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column.

For example:

Column A: Yes

Column B: Yes

Total: 1

Everyone formula I'm setting always gives either 0 or 2

Hopefully that makes sense.

Many thanks

 

 

Chris McKay

Hi Nick,

You're essentially asking Smartsheet to COUNT, but then ignore. It's not going to do that without bending the laws of physics.

If all you're after is a 1 count if wither column contains a "Yes", why don't you simply use:

=IF(OR([Column A]@row = "Yes", [Column B]@row = "Yes"), 1, "")

Kind regards,

Chris McKay

Nick Randall

Hi Chris

This works, thank you! It was late my time and I didn't feel up to bending physics at that point...

Much appreciated.

Kind regards

Nick

Chris McKay

Haha. Happy it worked for you.

Kind regards,

Chris McKay