Formula Assitance

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.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this:

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.