This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I would like to know if it is possible to introduce an expression like the one I use in EXCEL inside an appsheet column, based on the table in the picture.
AppSheet does have a LOOKUP() function. However it is typically used in the context of AppSheet app's tables and columns. Depending on the data schema of your app, you could use it suitably.
In your example your values in G and H columns should typically be in an AppSheet table /columns unless you wish to use fixed values.
AppSheet does have a LOOKUP() function. However it is typically used in the context of AppSheet app's tables and columns. Depending on the data schema of your app, you could use it suitably.
In your example your values in G and H columns should typically be in an AppSheet table /columns unless you wish to use fixed values.
Thank you so very much for your answer. Precisely according to what you wrote: "...it is typically used in the context of AppSheet app's tables and columns", that is what I am trying to do. But I do not know how though I have tried.
LinkedIn
Twitter
