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

Samantha Rice

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!

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)

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.