Spreadsheet formula doesn't work by saving

[JérémyK]

Hi everyone

I have a spreadsheet formula that was automatically added by Regenerate Structuture:

=ArrayFormula(XLOOKUP(RC1&RC5,Bouteilles!C1:C1&Bouteilles!C3:C3,Bouteilles!C[2]:C[2],"",0))

My problem is that when I save, the formula is not added to the sheet. Could someone tell me why?

Thanks in advance

[AleksiAlkio]

AppSheet is not able to do that with arrays even the sheet formula is copied.

[AleksiAlkio · Accepted solution]

https://support.google.com/appsheet/answer/10104397?hl=en

[JérémyK]

That was my fear
Thanks for your help

[AleksiAlkio]

Though this doesn't mean that you can't use Arrayformula(), but you need to use it only in one row, remove the sheet formula from the editor and set that column as read_only.

[JérémyK]

Another question
Is it possible in this case to use a bot or a data action to implement this formula?

[AleksiAlkio]

Don't know all the details from your goal, but it should.