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!

Find more posts tagged with

Formulas

Accepted answers

heyjay

How about this?

=IF(AND(
Phase@row = "Milestone", 
Finish@row <= DATE(2024, 3, 11)), 1, 0)

All comments

heyjay

=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)

Shuai Yao

https://community.smartsheet.com/discussion/comment/416363#Comment_416363

Thanks!!! I used 1,0 too but it didn't work, I just copied your formula to the column, it shows INVALID OPERATION

heyjay

How about this?

=IF(AND(
Phase@row = "Milestone", 
Finish@row <= DATE(2024, 3, 11)), 1, 0)

Shuai Yao

https://community.smartsheet.com/discussion/comment/416373#Comment_416373

OMG, you made my day. Thank you!!!!It worked!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.