0

Replacing two values in the same formula

Hi,

What would be the syntax to using a single formula to replace 2 different values? Right now I'm using the formula below that works for a single state, but also trying to replace Penn. with Pennsylvania in the same formula.

(replace(

    Location, 

    "Cali", 

    "California"

)

 

Thanks,

John

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi John Finnerty - Welcome to the community. We're glad to have you here!

    I would lean towards writing multiple conditions using a CASE statement:

    case(

    Community.Sheet1.Abbrv = 'Oh','Ohio',

    Community.Sheet1.Abbrv = 'Mich','Michigan',

    Community.Sheet1.Abbrv = 'Penn','Pennsylvania',

    Community.Sheet1.Abbrv = 'Ore','Oregon',

    ''

    )

    Like
      • John Finnerty
      • Quanta Services
      • John_Finnerty
      • 11 days ago
      • 1
      • Reported - view

      Joe Miller Thanks Joe! I ended up going that route

      Like 1
Like Follow
  • Status Answered
  • 11 days agoLast active
  • 2Replies
  • 10Views
  • 2 Following

Product Announcement

Incorta 5 is now Generally Available