Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF AND Remove Text

Topic Labels: Formulas
Solved
Jump to Solution
1289 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Smyth_County
6 - Interface Innovator
6 - Interface Innovator

I'm trying to write a formula to remove the "➟" if the preceeding field is empty.

Current Formula:

Origin" ➟ " &{Destination}&" ➟ "&{Backhaul From}" ➟ "&{Backhaul To\\Return}" ➟ " &Origin &" - LANE #" & {LANE#} 
 
Here is the output of the above formula.  Formula above works great, (example 1 below) but if there is no data in {Backhaul From} and {Backhaul To\\Return} the result is example 2 with 2 extra arrows.  Example 3 is the desired results.
 
1) Walmart ➟ Kroger ➟ Target ➟ Walmart - Lane # 1
2) Walmart ➟ Kroger ➟ ➟ ➟ Walmart - Lane # 2
3) Walmart ➟ Kroger ➟ Walmart - Lane # 2
 
I've tried BLANK() IF AND with no luck.  Can this be accomplished?
 
2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using an IF for each field:

Screenshot 2024-03-20 at 10.40.18 AM.png

Origin & 
IF(
  Destination,
  " ➟ " & {Destination}
) &
IF(
  {Backhaul From},
  " ➟ " & {Backhaul From}
)

See Solution in Thread

pressGO_design
10 - Mercury
10 - Mercury

Origin" ➟ " &{Destination}&
IF({Backhaul From}, " ➟ "&{Backhaul From})&
IF({Backhaul To\\Return}, " ➟ "&{Backhaul To\\Return})&
 " ➟ " &Origin &" - LANE #" & {LANE#} 

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try using an IF for each field:

Screenshot 2024-03-20 at 10.40.18 AM.png

Origin & 
IF(
  Destination,
  " ➟ " & {Destination}
) &
IF(
  {Backhaul From},
  " ➟ " & {Backhaul From}
)
pressGO_design
10 - Mercury
10 - Mercury

Origin" ➟ " &{Destination}&
IF({Backhaul From}, " ➟ "&{Backhaul From})&
IF({Backhaul To\\Return}, " ➟ "&{Backhaul To\\Return})&
 " ➟ " &Origin &" - LANE #" & {LANE#} 

Thanks this worked!  

Thanks this worked!