Skip to main content
Solved

IF AND Remove Text

Forum|alt.badge.img+5

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?
 

Best answer by TheTimeSavingCo

Try using an IF for each field:

Origin & IF( Destination, " ➟ " & {Destination} ) & IF( {Backhaul From}, " ➟ " & {Backhaul From} )
View original
This topic has been closed for replies.

4 replies

TheTimeSavingCo
Forum|alt.badge.img+32

Try using an IF for each field:

Origin & IF( Destination, " ➟ " & {Destination} ) & IF( {Backhaul From}, " ➟ " & {Backhaul From} )
Adam, Airtable Consultant - https://thetimesaving.company
pressGO_design
Forum|alt.badge.img+22

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

Forum|alt.badge.img+5
  • Smyth_County
  • Author
  • Participating Frequently
  • March 20, 2024

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


Thanks this worked!  

Forum|alt.badge.img+5
  • Smyth_County
  • Author
  • Participating Frequently
  • March 20, 2024

Try using an IF for each field:

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

Thanks this worked!

    Terms & ConditionsAccessibility statement