Sending Excel Functions through Make Its Not Working

[Alvaro_Souza]

Hello everyone ,

the thing is that I am trying to send an Excel function through Make using a webhook from glide to end up in an excel table, but I have received an error stating that the argument is invalid or missing or has an incorrect format. The formula I am trying to send is the following:

=SI([@Situación]="Aceptado";SI([@Zapatos]="No Necesito";;"Zapatos size: "&[@Zapatos])&SI([@Pantalones]="No Necesito";;", Pantalones size: "&[@Pantalones])&SI([@Parka]="No Necesito";;", Parka size: "&[@Parka])&SI([@Chaqueta]="No Necesito";;", Jacket size: "&[@Chaqueta])&SI([@[Ropa interior]]="No Necesito";;", Underwear size: "&[@[Ropa interior]])&SI([@Guantes]="No Necesito";;", You need Gloves: "&[@Guantes])&SI([@[Lentes de Sol]]="No Necesito";;", You need Sunglasses: "&[@[Lentes de Sol]])&SI([@Casco]="No Necesito";;", You need a Helmet: "&[@Casco])&SI([@Bloquiador]="No Necesito";;", You need Sunscreen: "&[@Bloquiador]);"Order Cancelled or Pending")

Could someone help me solve this problem? Is there a problem with the formula or with the way I am sending it?

Thank you in advance for any help you can provide.

Best regards.

[Jeff_Hager]

Wouldn’t it be better to use an array formula in the excel sheet? Then each row would have the formula applied automatically.

If that value is only needed in the app, it would actually be a lot better to apply formulas within glide using an IF column or an Excel Formula column.

[Alvaro_Souza]

I must admit, I feel a bit embarrassed that I didn’t know the answer myself , but I am extremely grateful for your comprehensive and helpful response. Thank you very much for your assistance.