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!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!