Can I use an IF formula to populate a checkbox?

Andrew Ryback

Hi everyone,

I'm building a simple project management sheet and am looking to add a flag (checkbox) if the end date for the task has passed and the task is still marked as "not started" or "in progress".

Is there a way to automate this using an IF formula?

Thanks!

Paul Newcome

Yes. It would look something along the lines of

=IF(AND([End Date]@row< TODAY(), Status@row <> "Complete"), 1)