Obtain UPPER(LEFT with multiple FIND options

I'm very new to smartsheets and to function formulas. I have a list of server names and I'm trying to obtain the location from our naming standard. I got it to work for all servers that are Production, "pl" but now I have staging servers "sl".

Example server names in my Hostname column:

l1plservername

nap2plservername

sn3slservername

The function I got to work with just the "PL" names is:

=UPPER(LEFT(Hostname@row, FIND("pl", Hostname@row) - 1))

I've been banging my head for 2 days trying to figure this out. 😫 But I just can't figure out how to add in the new search criteria to include server names that have SL . If anyone has anything I could try, that would be great!

Also, any suggestions on how to best learn function formulas - seems like smartsheets loves these 😊

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try using an IF statement to say that if it contains "pl" then runt eh "pl" formula, otherwise run the "sl" formula.

=IF(FIND("pl", Hostname@row) > 0, UPPER(LEFT(Hostname@row, FIND("pl", Hostname@row) - 1)), UPPER(LEFT(Hostname@row, FIND("sl", Hostname@row) - 1)))

All comments

Paul Newcome

Try using an IF statement to say that if it contains "pl" then runt eh "pl" formula, otherwise run the "sl" formula.

=IF(FIND("pl", Hostname@row) > 0, UPPER(LEFT(Hostname@row, FIND("pl", Hostname@row) - 1)), UPPER(LEFT(Hostname@row, FIND("sl", Hostname@row) - 1)))

Candace Lannon

Thank you Paul! That worked perfectly.

Paul Newcome

Happy to help. 👍️

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.