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.

Left Mid Right Not Working for Variables

Topic Labels: Formulas
Solved
Jump to Solution
1723 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!