Either / Or but not both
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
Comments
-
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
-
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
-
Haha. Happy it worked for you.
Kind regards,
Chris McKay
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!