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 have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
Hi all, I have a bunch of underlying sheets that have the exact same setup due to a template and it has a status field with a drop-down of about half a dozen different options that go sequential order from not started to complete and verified as complete from leadership. We also have hierarchy so there is level 0, 1 and 2…
We are using Smartsheet for a sign up process with forms and automations. However, automation emails seem to have a limit of 20 rows per email. We need assistance in finding a way to increase this limit or explore alternative solutions.
