Need help with formula (first value that is not a specific criteria)

nd0224 ✭✭
edited 01/24/24 in Formulas and Functions

I want the Field next to "Current Phase" to return the first Phase for which Status is NOT 100%. What type of formula could I use for that?

For example, Phase 4 is what I'm needing the cell to populate (right now it's manually inputted)

Any help is appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!