I have a column [Upload] of type image. The value given is something like Form Responses_Images/136D24A5.Upload.151157.com.jpg. I want to create a column with value 136D24A5.Upload.151157.com.jpg but when I use the formula RIGHT([Upload],30) I get gibberish. I’m guessing it’s because [Upload] is an image type and I can’t perform a Right() function on it. How can I convert the image type in my formula to text so that I can perform my function?
I have no clue if it will work but there is a TEXT() function. Maybe it will give you the image URL in text form before it is resolved to the actual image file?
RIGHT(TEXT([Upload], 30))
Alternatively, maybe there is an another way to accomplish your goal? Could you describe what your desired end result is?
Tom_automated:
I get gibberish.
Screenshot?
1 Like