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

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Automation not triggering all of the time
Hi Smartsheet community, I've always tried to answer questions but this is my first time posting. So I have formula =IF([Project Status]@row = "Complete", 1, 0) set up in the "Complete Check - Hide column" to check the box when the project status is marked complete. The project status column is tied to several other sheets…