Skip to main content

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?
 

Try using an IF for each field:

Origin &

IF(

Destination,

" ➟ " & {Destination}

) &

IF(

{Backhaul From},

" ➟ " & {Backhaul From}

)

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

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


Thanks this worked!  

Try using an IF for each field:

Origin &

IF(

Destination,

" ➟ " & {Destination}

) &

IF(

{Backhaul From},

" ➟ " & {Backhaul From}

)

Thanks this worked!

Reply


Terms & Conditions