Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 an end date column and want to add 30 days to that for a new column that shows due date. How do I add 30 days to a date automatically?
The dashboard previously contained 16 widgets, and I have confirmed that the widgets still exist in the backend. However, when I open the dashboard, nothing is displayed, and I am unable to enter Edit Mode or access the widgets/data sources. I have already confirmed the following: I am the owner of the dashboard and have…
Why is it so convoluted now! I eventually figured out the changes and ended up with a sheet that Smartsheet completely reorganised the rows and the sheet is now useless to me as it is not in a logical order for me to easily restore to its original layout. This is not an "improvement"! It was far easier to upload data…
