Checkbox with IF AND formula- satisfy two criteria simultaneously


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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!