Sign in to join the conversation:
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.
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)
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.
Try changing
TODAY() > [Start Date]@row
to
TODAY() >= [Start Date]@row
The same can be done with the End Date as well.
thank you!
Happy to help!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
