Assistance with Formula- Current Phase

I would like to highlight the stage that my project is currently in. I have been using the following formula but continue to get a #unparseable and not sure what I might be missing.

My formula is: =INDEX(COLLECT([Task Name]:[Task Name], [% Complete]:[% Complete], @cell < 1, Ancestors:Ancestors, @cell = 2), 1, 1)

Any help is greatly appreciated, thanks!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!