Formula to check box when 2 criteria are met: older than 180 days and another box is checked

I can't get get my formula to work. I am trying to get a box in one column to check when the date in another column exceeds or is equal to 6 months (180 days) and when another box in a third column is checked. This is what I have, but I think it's the checkbox condition that's throwing things off:

=IF(AND([Start Date]@row >= TODAY(180), [Uniformed Employee]@row = "1"), 1, 0)

For the Uniformed Employee checkbox, I have tried removing the quotations, changing the equal sign to a comma, changing the 1 to greater than 0. Please help!

Find more posts tagged with

Formulas

Accepted answers

Jackie Ziemke

For my formulas with check boxes, use "True" (checked) and "False" (unchecked) instead of "1 and 0" give that a shot!

Below is a formula I use to check the anniversary column if the start date is this month, and they are not a new hire.

=IF(AND(MONTH([Anniversary Date]@row) = MONTH(TODAY()), [New Hire This Month?]@row = "false"), true, false)

Jacob Mizer

Try =IF(AND([Start Date]@row <= TODAY(-180), [Uniformed Employee]@row =1), 1, 0)

All comments

Jackie Ziemke

For my formulas with check boxes, use "True" (checked) and "False" (unchecked) instead of "1 and 0" give that a shot!

Below is a formula I use to check the anniversary column if the start date is this month, and they are not a new hire.

=IF(AND(MONTH([Anniversary Date]@row) = MONTH(TODAY()), [New Hire This Month?]@row = "false"), true, false)

Jacob Mizer

Try =IF(AND([Start Date]@row <= TODAY(-180), [Uniformed Employee]@row =1), 1, 0)

Samantha Rice

Thank you both for your advice! The negative 180 worked and I didn't realize you could use true/false instead of 1/0.

Jacob Mizer

Anytime, Here is a tip, When I work on if or if(and, I break down each "if" to make sure it works before i put them together.

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.