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
Hi, I am a user for a paid plan, but for some reason, smart sheets stopped letting me edit. How do i fix this so that i can edit a dashboard? Thanks!
The timeline widget has a toggle: Set the default hierarchy state. I am turning on "expand lanes by default." It seems regardless if I turn this "on", save, sign out, and sign back in, it automatically changes back to "off" when I log out. I have tried clearing my browser cache.
Hi Everyone, We currently have a Smartsheet business plan and we wanted to know if it was possible to invite people into workspaces, but limiting what they see in the workspace. A few users would like to be able to edit some sheets within this workspace, but it is not allowed since their accounts are set as viewers. Is…
