Can I use both LEFT and UPPER functions at the same time?
I want to take "Report" and get "REP" in the TypeCHAR column.
Best Answer
-
I figured it out...
=UPPER(LEFT(Type@row, 3))
Report becomes "REP"
Answers
-
I figured it out...
=UPPER(LEFT(Type@row, 3))
Report becomes "REP"
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!