Formula to return last completed phase
Hello Smartsheet Community.
I have created a formula that returns the current phase of a project based on the input of the project number:
It works great, but it returns a blank if the project is in lag time between phases. I can also get it to return either the current phase or the next upcoming phase if I look for the next end date that is in the future:
Is there a way to get it to return either the current phase or the last completed phase if the project is in lag time?