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
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Hello, I have a column with a restricted list of 100 entries. When I edit the list and scroll to the 50th entry, as soon as I type to change the entry name the column scrolls to the top and I cannot see what I am typing or deleting. I have to keep scrolling back down to the row to see what I have keyed in. Very annoying…
