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 got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
