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

nd0224
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!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!