Welcome!

IF todays date is between start date and end date then check this box

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.

Find more posts tagged with

Formulas

Comments

Mike Wilday

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

Try adding this formula and dragging down through the rows.

Paul Newcome

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

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

kjsneaks

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.

Paul Newcome

Try changing

TODAY() > [Start Date]@row

TODAY() >= [Start Date]@row

The same can be done with the End Date as well.

kjsneaks

thank you!

Paul Newcome

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Date/ Time cutoff tracking
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?