Solved: Adding text to a number column in Google Sheet - Page 2

David_B · 10-11-2019 05:27 AM

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.

Suvrutt_Gurjar

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?

View solution in original post