LinkedIn
Twitter
I am trying to group by date (in the MM/YYYY format). However, the grouping shows invalid date.
II think that the reason for the error is because the Excel sheet uses a formula to pull the date. Below is the Excel formula - Note - this is an array formula.
{=TEXT(MIN(IF(‘System Components’!$A$2:$A$2000=‘Client Data’!A2,IF(‘System Components’!$D$2:$D$2000<>0,‘System Components’!$D$2:$D$2000))),“mm/yyyy”)}
If I copy the cells in the Excel and paste them as ‘values’, then the grouping works as it should. But when the cells contain the formula, then the grouping does not work.
In Appsheet, for the date column in question, the ‘spreadsheet formula’ that Appsheet has generated for me is: =ArrayFormula(MIN(IF(‘System Components’!R2C1:R2000C1=‘Client Data’!RC[-8],IF(‘System Components’!R2C4:R2000C4<>0,‘System Components’!R2C4:R2000C4))))
Can someone please help me solve this - I’d like to keep the formula in the excel cells and enable grouping on this column by date (Ascending).
I have tried to create an additional column and reference the column with the array formula, but this still shows invalid date.
