Help

Nested Formula Help (Nested + Text Contains + Formatting)

Topic Labels: Formulas
685 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Caleb_Barclay
4 - Data Explorer
4 - Data Explorer

I’m trying to write a formula that would format a long text to a short formatted text. Example: “We offer just the drawings and floor plan in addition or exclusively as a service” to “floorplan-only”

The tricky part is there are 4 different types:

Service Type (Single line text)

  1. Nothing, we are a turn-key service, from site prep, permits, to completion
  2. The client has some responsibility like permits, site-prep, and transportation
  3. We just send the kit of parts and the client takes care of the majority of work
  4. We offer just the drawings / floor plan in addition or exclusively as a service

And I want to change it to the following based on the above text:

Formatted (Formula)

  1. turn-key
  2. door-step
  3. kit-of-parts
  4. floorplan-only

What I want is the formula to pull any of the four fields and format it. For example, if the service type was all four, the formatted cell would have: turn-key; door-step; kit-of-parts, floorplan-only. I’m not sure how to add that type of logic and how to add “;” in-between the types.

I tried this formula but it didn’t work as it only picks “AND” logic.

IF({Service Type} = "The client has some responsibility like permits, site-prep, and transportation", "doorstep", IF({Service Type} = "We just send the kit of parts and the client takes care of the majority of work", "kit-of-parts"))
0 Replies 0