If all = Competent then competent, if not, then inconsistent

Hi all,

I need help with a formula. People choose their skill based on a certain topic:

  • Competent
  • Inconsistent
  • Expert

I need a formula that looks at all the children and determines that:

  • If 1 inconsistent, no matter what else, show as inconsistent
  • If all competent or expert, show as competent

I am guessing it can be easily achieved by saying if there is 1 inconsistent then inconsistent, otherwise, show competent. But i am not sure how this will look in a formula?

Any help would be much appreciated.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!