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've found Paul Newcome's mega post on calculating hours and from that have successfully created the total number of hours worked. But I am trying to have it calculate net hours worked after taking away any unpaid break. Breaks will be 30 mins or 60 mins. I've seen other posts from people asking about it but haven't seen…
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
Hello! I am attempting to create a dashboard widget that shows me how much budget we are spending in each segment, and in what category. The source sheet contains these columns… "Budget" - text/number column "Category" - dropdown list (restricted to list values only) "Segment" - dropdown list (allows multiple values per…
