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.
Help Article Resources
Check out the Formula Handbook template!