IF AND statement with TODAY function

I am trying to write a formula where if the date in the "Date" column is greater than or equal to today AND the "Attended" column checkbox is not checked, then check the box in the "Missed" column box so that a notification will go out to all of those who missed the training.

This is what I have that is giving me an #INVALID

=IF(AND(Date@row >= TODAY(), Attended@row = 0), 1, 0)

Thank you for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!