Auto Checkbox Formula - past the date

laura.sandoval

Hello, I'd like to have some kind of formula for the checkbox for it to be checked once the date is passed...meaning the meeting has been completed. That way we don't have to manually do it and probably forget to do it. What kind of formula would I use?

Paul Newcome

There should be a comma before the 1.

Paul Newcome

Try this:

=IF(TODAY()> [SQV Date]@row, 1)

laura.sandoval

Hii thanks for answering! I'm getting an error message on it :( any thoughts?

Paul Newcome

There should be a comma before the 1.

laura.sandoval

Yay it worked thank you!

Paul Newcome

Happy to help. 👍️

Liz Wallace

@Paul Newcome how can I add to this equation to not mark lines that are blank in the date column as late?

Paul Newcome

@Liz Wallace You would start it with another if.

=IF([Date Column]@row <> "", rest_of_original_formula)

Liz Wallace

@Paul Newcome this is what I am trying and its not working =IF([Due Date]@row<>,(TODAY() > [End Date]@row, 1)

Liz Wallace

This was my current column formula" =IF(TODAY() > [End Date]@row, 1)

Paul Newcome

@Liz Wallace Your syntax is off. You are missing the double quotes before the first comma and the IF before the opening parenthesis before TODAY().