Formula Assitance

Ryan Ferreira

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.

Paul Newcome

Try something like this:

=VALUE(LEFT([Deal Qty]@row, FIND("+", [Deal Qty]@row) - 1))