Help

Left Mid Right Not Working for Variables

Topic Labels: Formulas
Solved
Jump to Solution
1396 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ssanto88
5 - Automation Enthusiast
5 - Automation Enthusiast

This feels really silly but I can't get the LEFT, MID, RIGHT, functions to work with variables at all. It just keeps giving me an error no matter what I try. It works with a string in the function but not if I use a variable. Can someone tell me what I'm missing? I'm sure it's something simple...

//Formula that doesn't work:
LEFT({Text Phone}, 3) => #ERROR!

//Formula that does work:
LEFT("123456789", 3) => 123
1 Solution

Accepted Solutions
CJSmith
7 - App Architect
7 - App Architect

Hi @ssanto88, I think the issue is the source is a lookup field instead of a string or number. I just replicated the issue, and the solve was turning the lookup into a text string as follows:

LEFT(CONCATENATE({Text Phone}), 3)

Let me know if that helps!

See Solution in Thread

2 Replies 2
CJSmith
7 - App Architect
7 - App Architect

Hi @ssanto88, I think the issue is the source is a lookup field instead of a string or number. I just replicated the issue, and the solve was turning the lookup into a text string as follows:

LEFT(CONCATENATE({Text Phone}), 3)

Let me know if that helps!

ssanto88
5 - Automation Enthusiast
5 - Automation Enthusiast

That did it, thanks for the help @CJSmith!