Formula to check a box if a condition is met, if not it must stay unchecked

Hi all,
I have 3 columns, and I need columns "Bonus Y" and "Bonus N" to check if "Bonus Eligible" says "Yes" or "No" and if it does not have any data, then the check boxes must remain unchecked.
I have the following formulas in the columns:
Bonus Y: =IF([Bonus Eligible]@row = "yes"; 1; 0)
Bonus N: =IF([Bonus Eligible]@row = "yes"; 0; 1)
So my formulas work when there is data in column "Bonus Eligible", but when it's empty then "Bonus N"'s check box is selected. I only need the boxes checked according to the Yes and No condition. Please can you help?
Thanks
Best Answer
-
You have your Bonus N formula's 0 and 1 backwards.
=IF([Bonus Eligible]@row ="no";1,0)
The way that you have it written in your example is to check if the IF is NOT true. If we want it to be check if it IS true, the 1 needs to come first.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
Answers
-
Would it be viable for in your Bonus N to just change the parameter to check for no?
=IF([Bonus Eligible]@row = "no"; 1; 0)
Based on that, it would leave all that do not apply unchecked, the same way your yes formula does.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
-
Thank you for your assistance.
Unfortunately it's not helping, it is now checking both columns (Bonus Y and Bonus N) if there is Yes in, and when there is No, then it removes the check, and when there is nothing then Bonus N is still checked.
Bonus Y: =IF([Bonus Eligible]@row = "yes"; 1; 0)
Bonus N: =IF([Bonus Eligible]@row = "no"; 0; 1)
-
You have your Bonus N formula's 0 and 1 backwards.
=IF([Bonus Eligible]@row ="no";1,0)
The way that you have it written in your example is to check if the IF is NOT true. If we want it to be check if it IS true, the 1 needs to come first.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Always happy to work through questions or concerns!
-
Oh my word, it is working......thank you, you are amazing!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!