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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!