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:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi,
I need a function to look at If a column completed date is blank and the end date column date i s more than today to the return status "overdue" so I can report on overdue tasks ?
this works
=IF(ISDATE([completed date]1), "", IF(TODAY() > [end date]1, "overdue", ""))
this one checks to make sure end date has a value
=IF(ISDATE([completed date]1), "", IF(TODAY() > [end date]1, IF(ISDATE([end date]1), "overdue", ""), ""))
Great thanks Tracy,
That works a treat just what I needed
James: Will other folks access this overdue information via reports, or will your overdue tasks be noted only within the sheet?
Yes a Report will flag the overdue information accesable by others as well
James: Cool. Then, I have another question for you. I've got a similar set-up. I've noticed, however, that the formulas do not update, unless you open up the sheet. This isn't an issue normally, if you are in that sheet every day. However, if you are out of the office for a while and nobody opens the main sheet, then the overdue calculations are not updated on the reports. Please let me know if you see this too.
