Adding text to a number column in Google Sheet

Is there a way to add text to a number column in my Google Sheet?
I have the Item # auto generated using (MAX(MainTable, [Item]) + 1)
I’d like the App to add the word Item in front of each number in my Google Sheet if that’s possible.
The field has to stay a number field in order for the auto generating formula to work.
If the word Item can be added in front of each number then a user can search for Item 5, etc.
As it is I can search for 5 and it will bring up item 5, but it will also bring up any item that has a 5 in it.
IE. 9/25/2019 14:53:06
But, I need to be able to search for particular items by it’s item number.

Hi @David_B,

Please explore if following workaround helps.I believe the appuser will search the item number in only summary view. So you may wish to create a VC with an expression similar to

CONCATENATE(“Item”," ",[Item])

You may then have a CONTEXT(“View”) expression in this VCs’ show_if to display it only in summary views. Then you may search on this field with word “Item” prefix.

Please note that if the user uses even slightly different pattern to search say Item5 instead of correct format Item 5 or even Item 5 ( double space after prefix) the search will not work.

Hope this helps.

Also could you you please mention if Item # is a key field in the said table?

3 Likes

Bless you, that worked like a charm.
And, yes Item is a key field.

1 Like

Hi @David_B,
Thank you for the update. Good to know the approach works the way you want.

On key, presume you have already evaluated the impact of using a serial number key generation system 's challenges in a multi user app environment.

Just in case not, you may wish to go through help article titled " What is a key" on AppSheet’ help document section.

1 Like

I will, thanks.

1 Like