Is there an alternate formula to the "EXACT" excel function?

Jennifer Langan

I need to return a value, (let's say "Yes"), if the text in a cell is all CAPS. Is this possible in Smartsheet since the EXACT function is not available?

Thanks in advance for your help!

Ayelet Weiner

Not to my knowledge, but you can add a column and use the LOWER or UPPER function to convert all text to the same format.

=LOWER([Column with your text])

=UPPER([Column with your text])

https://help.smartsheet.com/function/upper

https://help.smartsheet.com/function/lower