Summing Mixed Text and Number Column


Greetings. New to Smartsheets. First time question. I have form entries that looks like this:

333 . 11111 - Parts

333 . 22222 - Service

I want to sum all entries from the form that begin with "333" and I cant seem to make it work. I dont want to divide my columns. I'm currently using a SUMIF formula and playing with a FIND and @cell for the criterion piece. The answer is going back and forth between 0 and #UNPARSEABLE, depending on how I play with it. Does anyone have any insight? Please and thank you!

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!