New doc: IN()

[Steve]

Finally!!!

help.appsheet.com

IN()

Is item in list?

[Kirk_Masden]

I’m a fan of this function and have wound up using it a lot in the main app I’m continuing to tweak. The function is related to something I wrote about earlier on this forum:

Put multiple values in single cells to reduce writing time Tips & Tricks 💡

Recently, I’ve been putting multiple values into single cells in order to reduce the number of “writing events” (I’m not sure what the proper term is) to my spreadsheet. For example, I can used an expression like concatenate([Value1],", “,[Value2],”, ",[Value3]) to put three values in one cell. Then, in the app, I can access them using combinations of split() and index() expressions. For example, if [Value2] is a number and the name of the column that contains [Value2] is [Example], the f…

[Kirk_Masden]

Hi @Steve! I just noticed that we can’t search for “IN()” on either this forum or the documentation site. “in” must be considered to be too short and too common.

I think I’ll call this “indocumentation”. Perhaps I’ll be able to find indocumentation if I search for it in the future.

[Kirk_Masden]

Yup. “Indocumentation” works.