nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

kjsneaks

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

HOW TO USE IF BLANK WITH THIS FORMULA
I am using this formula to return the month and year from a reference date, but cannot figure out how to use IFBLANK with it in order to return a blank cell if the reference date cell is empty. This is the formula I am using and trying to add IFBLANK to. =IF(MONTH([WALL DESIGN FINISH (ACTUAL)]@row) = 1, "01-",…
Need help with a formula to determine if all responses have been received for each group in the Smartsheet
Hi! Thanks in advance for taking a look! I have a Smartsheet that has a line for each person being reviewed as well as their "client number". I created a helper row to let me know when each person has completed their actions, but I'm having a hard time finding a way to indicate when everyone for that client number has…
COUNTIF Cells within a range are NOT BLANK
Hello, need help with a formula - I need to count within a cell range how many are NOT BLANK, this is the formula I currently have that is not working - what needs to be changed? /COUNTIF(Charter@row:[Retrospective/Lessons Learned]@row, <>"")