Formula Assitance
Options
Good Day Smartsheet Community.
I am looking for assistance on a basic formula which i i can do in excel but cant seem to come right in Smartsheet.
I want a column to return a value/number but remove the remaining value/numbers.
The column is called Deal Qty and has a value of 240+24 but all i want in the next column is the 240.
Not all the values are the same, some are 1200+50 or 1600+40 or 240+24 but i only want the values from before the + sign.
Thank you in advance.
Answers

Try something like this:
=VALUE(LEFT([Deal Qty]@row, FIND("+", [Deal Qty]@row)  1))
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!