I need to run an active projects report that collects data on in progress projects. I need to put the formula into the checklist column so that it checks it if todays date is between the start and end date.



=IF(AND(Today()<[End Date]@row, Today()>[Start Date]@row),1, 0)

Try adding this formula and dragging down through the rows. 

In reply to by Mike Wilday

Thank you for your answer it helped but is there a way to have it include the jobs started today. If the job is 1 day long to complete it wont be checked.


You can also add in your In Progress criteria within the AND function.


=IF(AND(Today()<[End Date]@row, Today()>[Start Date]@row, [email protected] = "In Progress"),1, 0)