
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 08:38 AM
Give me advice please how I can choose just the least sumbol in the cell. Or for example 5 least symbols.
Using look up I have many developments, but I want to have just the least one.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 06:20 PM
Lookup fields create arrays, not strings, and RIGHT requires a string. To convert an array to a string, concatenate it with an empty string. Doing that combined with RIGHT gives you this, which should work:
RIGHT({Наличие в Холодильнике} & "", 1)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 08:55 AM
Assuming the “symbol” is 1 character in length, make a formula like this: RIGHT({Name of your field}, 1)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 09:41 AM
Thanks! But how I know this formula works when we have a text, line. For example, I cannot make RIGHT({Name}, 3), but I can find RIGHT(“Name”, 3)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 10:22 AM
? RIGHT()
should work for fields, including lookups. Can you post a screenshot of what your problem is?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 10:57 AM
I cannot make a screenshot)
I have a column with 1 and zeros. I got them with lookup.
And from this cells I want to get the last number using RIGHT({Наличие в Холодильнике}, 1) formula. At the result it shows #ERROR :frowning:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2019 06:20 PM
Lookup fields create arrays, not strings, and RIGHT requires a string. To convert an array to a string, concatenate it with an empty string. Doing that combined with RIGHT gives you this, which should work:
RIGHT({Наличие в Холодильнике} & "", 1)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 05, 2019 01:12 AM
I can’t believe, it works! Thanks :heart_eyes:
