Checkbox with IF AND formula- satisfy two criteria simultaneously
Hi,
I want to add a formula to a checkbox column, the purpose is to automatically check the box once the cell satisfies two criteria simultaneously.
Criteria 1: Phase column=Milestone
Criteria 2: Finish Date column<= 03/11/2024
I have tried a few IF AND formulas but still can't get the result desired, loosing temper now :(
This is my current formula:
=IF(AND(Phase@row = "Milestone", Finish@row <= "03/11/24"), "yes", "no")
Please help thank you!
Best Answer
-
How about this?
=IF(AND( Phase@row = "Milestone", Finish@row <= DATE(2024, 3, 11)), 1, 0)
...
Answers
-
=IF(AND( Phase@row = "Milestone", Finish@row <= date(2024, 3,11), "1", "0")
1 and 0 are the switches for checkboxes.
For DATEs, use the function
DATE (YYYY,MM,DD)
...
-
Thanks!!! I used 1,0 too but it didn't work, I just copied your formula to the column, it shows INVALID OPERATION
-
How about this?
=IF(AND( Phase@row = "Milestone", Finish@row <= DATE(2024, 3, 11)), 1, 0)
...
-
OMG, you made my day. Thank you!!!!It worked!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!