Mar 19, 2024 01:01 PM - edited Mar 19, 2024 01:26 PM
I'm trying to write a formula to remove the "➟" if the preceeding field is empty.
Current Formula:
Solved! Go to Solution.
Mar 19, 2024 07:40 PM
Try using an IF for each field:
Origin &
IF(
Destination,
" ➟ " & {Destination}
) &
IF(
{Backhaul From},
" ➟ " & {Backhaul From}
)
Mar 19, 2024 07:43 PM
Origin& " ➟ " &{Destination}&
IF({Backhaul From}, " ➟ "&{Backhaul From})&
IF({Backhaul To\\Return}, " ➟ "&{Backhaul To\\Return})&
" ➟ " &Origin &" - LANE #" & {LANE#}
Mar 19, 2024 07:40 PM
Try using an IF for each field:
Origin &
IF(
Destination,
" ➟ " & {Destination}
) &
IF(
{Backhaul From},
" ➟ " & {Backhaul From}
)
Mar 19, 2024 07:43 PM
Origin& " ➟ " &{Destination}&
IF({Backhaul From}, " ➟ "&{Backhaul From})&
IF({Backhaul To\\Return}, " ➟ "&{Backhaul To\\Return})&
" ➟ " &Origin &" - LANE #" & {LANE#}
Mar 20, 2024 05:07 AM
Thanks this worked!
Mar 20, 2024 05:07 AM
Thanks this worked!