LOOKUP from several columns

AppSheet AppSheet Q&A
1

Hi!
I need to get an Average from several columns, if from several columns there is the same value.
Eg: I have 10 columns with duration type, and other 10 columns with email USER, I need to get the AVERAGE time of each user.
I know how to do it from a single column, but not from several columns.

Any thoughts ?

2

Soporte_GestionApp:

but not from several columns.

What do you mean by that?
Can you give us a better explanation about this?

[Guide on How To Create a Community Post](https://community.appsheet.com/t/guide-on-how-to-create-a-community-post/35855) Tips & Tricks ?

Dear valuable members and users, For a long time Iā€™m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help doā€¦

1 Like
3

I have 10 columns where the emails of the users are registered, these emails can be in column 1 as in column 10, in turn I have 10 columns where the working time of that user is registered.
I need to know what time each user spent on average.
Therefore, in each row, there can be registered from 1 user to 10 users with their respective working times.
I need to identify each user with their working time, so then I can make an average of their working time.
I also have a table where I register users with their email, so this can facilitate the filtering of the search

4

Primero que todo, creo que hablas espaƱol, espero no estar equivocado.
Por otro lado, por favor no te ofendas, pero me da la impresiĆ³n que el escenario que me indicas no estĆ” muy bien diseƱado, aunque puedo estar equivocado. Eso de ordenar los usuarios en varias columnas no me parece muy acorde al concepto de normalizaciĆ³n de la DB, aunque -repito- puedo estar equivocado.
Por quƩ debes hacerlo de ese modo?
Yo igualmente ocupo un concepto similar con una app de embarques de fruta en contenedores donde puede ser llenado en hasta 4 lugares, pero no es info que necesite resumir ni hacer reportes con ello por lo que no me he preocupado mucho en cuanto a si estĆ” bien o no, de todos modos funciona en mi caso, aunque planeo convertirlo en 1 sola columna enumlist base ref