Solved: Can I use IFS() expressions in templates? - Page 2

jcmoras · 08-07-2023 05:05 AM

Hi, I allready using IF expressions in templates.

https://support.google.com/appsheet/answer/11568425?hl=en&ref_topic=11445504&sjid=194117038092938038...

but , I am trying to use IFS() and I cannot figure it out.

Im searching for some example or information, cant find it yet.

jcmoras

Solved.

<<Start:[PUERTAS]>><<IFS(AND([SISTEMA]=”ABRIR”,[D4]=”70INT”,[COEF19]=”PLACA”,[CANTHOJAS]=1,[MANO]="DERECHA"),
CONCATENATE("[PRG]=HOJA_OPT.pgmx;[DX]=",[ALTO HOJA PANTOGRAFO],";[DY]=",[ANCHO HOJA PANTOGRAFO],";[DZ]=50;[ORDER]=",[TIPOLOGIA],";"),
AND([SISTEMA]=”ABRIR”,[D4]=”70INTD”,[COEF19]=”PLACA”,[CANTHOJAS]=2,[MANO]="DERECHA"),CONCATENATE("[PRG]=HOJA_DOBLE_ACTIVA.pgmx;[DX]=",[ALTO HOJA PANTOGRAFO],";[DY]=",[HOJA ACTIVA PANTOGRAFO],";[DZ]=50;[ORDER]=",[TIPOLOGIA],";","
","[PRG]=HOJA_DOBLE_PASIVA.pgmx;[DX]=",[ALTO HOJA PANTOGRAFO],";[DY]=",[HOJA PASIVA PANTOGRAFO],";[DZ]=50;[ORDER]=",[TIPOLOGIA],";"))>><<End>>

View solution in original post