Is there a way to make an if formula case sensitive?

I need an if function to evaluate to true only if the cell it is checking is in all caps, but right now it evaluates to true if it is lowercase, is there a formula to do this? Thank you!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Hmm... This is something I had started on a while back but had to put on the back burner because it wasn't a top priority for me.

    My initial thought was parsing out the text string, but that isn't very scalable and still presents some hurdles. I do know that the FIND function is case sensitive, so (untested) maybe we could try something like converting it to all upper case using the UPPER function then saying if the FIND function finds the upper case string in the original string, then the original string must be all upper case.

    Feel free to give it a shot and let me know how it works out. I'm not sure why I didn't think of it before. I will try to test on my own sometime later this evening.

    =IF(FIND(UPPER([Text String Column]@row), [Test String Column]@row) > 0, 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!