SELECT WITh two fields

AppSheet AppSheet Q&A
1

I have this formula that select the field Diagnóstico, but I want to select other field more

SELECT(DATOS[DIAGNÓSTICO], IN(DATOS[CLAVE], LIST([_THISROW].[CODIGO])))

Is possible Select two or more fields?,

I could do LIST(SELECT(DATOS[DIAGNÓSTICO], IN(DATOS[CLAVE], LIST([_THISROW].[CODIGO]))),SELECT(DATOS[FECHA], IN(DATOS[CLAVE], LIST([_THISROW].[CODIGO])))) but I don’t like.. I want

SELECT(DATOS[DIAGNÓSTICO]+DATOS[FECHA], IN(DATOS[CLAVE], LIST([_THISROW].[CODIGO])))

Thanks

2

You cannot retrieve two columns with one SELECT statement unfortunately.

1 Like