Sign in to join the conversation:
We have created a sheet which has a start date and a due date.
I would like to have the status column change to overdue once the due date is past the current date.
If someone would be able to help me that would be greatly appreciated.
Thank you
Dave
Hi Penny,
Try something like this.
=IF([Due Date]@row < TODAY(); "Overdue")
The same version but with the below changes for your and others convenience.
=IF([Due Date]@row < TODAY(), "Overdue")
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hello Smartsheet Community, Our company recently went through a domain/email change, and since then one of our team members has been unable to access her Smartsheet account because the previous email tied to the account is no longer accessible. We have attempted several times to update the account to the new email address,…
I inserted a dashboard in our staff portal (Sharepoint). There is a header I do not see when I am in the Dashboard. It appears when inserted onto a webpage. How can I hide it?
I am wanting to send a request for an update to our inventory control people when we have non-conforming material that needs to be contained in the system and physically. I have a column for each with a drop down of Yes, No,N/A. I have my automation setup for triggered when containment required changes to any value,…
