79120175

Date: 2024-10-24 01:49:19
Score: 1
Natty:
Report link

I have this issue between AppSheets and Google Sheets, when I insert a new Google Sheet Lines with AppSheets.

How can I solve the arguments delimiters in AppSheets to match Google Sheets ?

Google Sheet Formula:

=IF(Ingresos_y_Egresos[Fecha]="";"";
   IF(Ingresos_y_Egresos[Imputación]="Egreso";
     IF(Ingresos_y_Egresos[Divisa]=ARS;
       IF(Ingresos_y_Egresos[Importe Operación]="";"";
          Ingresos_y_Egresos[Importe Operación]*-1
         )
       ;
       ""
       )
     ;
     ""
     )
    )

AppSheets Formula: (inserted in Google Sheet)

=IF(Ingresos_y_Egresos[Fecha]="","",IF(Ingresos_y_Egresos[Imputación]="Egreso",IF(Ingresos_y_Egresos[Divisa]=ARS,IF(Ingresos_y_Egresos[Importe Operación]="","",Ingresos_y_Egresos[Importe Operación]*-1),""),""))
Reasons:
  • Blacklisted phrase (0.5): How can I
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Roberto Best