Create a formula that returns the current project phase in the project summary metadata sheet.


The phases in my project plan are Level 1. The formula should return the text value of the phase (task name) that has the least % started, NOT including phases at 0% or at 99% and higher.

=INDEX({Task Name}, MATCH(MAX(COLLECT({Level}, {Level}, AND(@cell, 1), {Level},1) AND(MATCH(MAX(COLLECT({Project 10 - % Complete}, {Project 10 - % Complete}, AND(@cell < 0.99, @cell > 0))), {Project 10 - % Complete}, 0)))))

It works, until I add in the Level 1.

Anyone have a suggestion?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!