Checking a checkbox if one checkbox is unchecked, another is checked and falls between 2 dates


How can I get the formula below to work?

=IF(AND([checkbox1]@row, 0, [checkbox2]@row, 1, [date]@row, >=DATE(2022, 4, 1), [date]@row, <=DATE(2022, 6, 30)), 1, 0)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!