Formula to count the number of characters after a symbol

Hello. I am attempting to write a formula that will count the number of characters that follow a "-", and use the resulting number to determine if the type should be a "PO" or a "SWA" using an IF statement.

I found a formula that will pull those characters following the "-", but it just gives me the actual 2 numbers following the dash, what I need to write the formula is:

IF (PO/SWA No@row) = 2 characters, "PO", otherwise "SWA"

Find more posts tagged with

Formulas

Accepted answers

Mike Wilday

Oh I see... Try this rendition.

=IF(LEN(RIGHT([PO / SWA No]@row, LEN([PO / SWA No]@row) - FIND("-", [PO / SWA No]@row)))=2, "PO", "SWA")

All comments

Mike Wilday

Try this: =IF(LEN([PO / SWA No]@row)=2, "PO", "SWA"

For more on the LEN Function see:

https://help.smartsheet.com/function/len

Natalia Kataoka

Hi @Mike Wilday , I tried that out but the formula returns the same Agreement Type every time, no matter the digits after the dash:

This is the formula I am using in row 1 that I have been attempting to modify to reach my desired end point: =RIGHT([PO / SWA No]@row, LEN([PO / SWA No]@row) - FIND("-", [PO / SWA No]@row))

Mike Wilday

Oh I see... Try this rendition.

=IF(LEN(RIGHT([PO / SWA No]@row, LEN([PO / SWA No]@row) - FIND("-", [PO / SWA No]@row)))=2, "PO", "SWA")

Natalia Kataoka

Great, that worked, thanks for your help!

Mike Wilday

Awesome, glad I could help you out.

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.