Solved: maxifs, minifs, textjoin not accepted by appsheet ... - Page 2

Chris_Bean1 · 06-04-2022 04:22 AM

Hi folks

I have some columns in a ms 365 Excel where I want to put maxifs, minifs and textjoin formulas, and appsheet is saying that these are not supported. However, I have another set of apps in google sheets where the following works fine and contains a textjoin (I have copied this from the 'Spreadsheet formula' part of the column definition):

iferror(join(", ",unique(transpose(split(arrayformula(textjoin(", ",1, rept('register'!C4:C4,('Register'!C8:C8=RC4)+0))),", ",0,1)))),"None found in sheet")

I would use appsheet formulas, but these don't stay in the cells like excel formulas do, and I want the column data to update based on data changes that will occur outside appsheet, in the excel itself.

Any reasons why textjoin would work ok in google with appsheet, but not in excel 365?

Thanks

Chris

Chris_Bean1

Ok after an age of messing about, I did this: I used a max formula in the spreadsheet then wrapped an if inside it:

=(MAX(IF('table1'!F:F='maxrow test'!A2,'table1'!C:C)))

I then regen'd the column, removed the 'array formula' text in 'auto compute' and did a couple of tests and it seems to be working.

Cheers

Chris

View solution in original post

maxifs, minifs, textjoin not accepted by appsheet in ms365 excel, but accepted in google sheets