Appsheet seems to not be able to pass along v...

(Adam Cole) #1

Appsheet seems to not be able to pass along values from Excel that are created by a table formula from another sheet. Here is the formula in Excel that is coming back as $#Name? in Appsheet. Anyone have any ideas?

=SUMIFS(Ledger[Amount],Ledger[Category],$A3,Ledger[Sub-Category],$B3,Ledger[Date],">="&($M$1),Ledger[Date],"<="&EOMONTH($M$1,0)).

(Philip Garrett) #2

Could you try eliminating the hyphen in “Sub-Category”?

I am not sure if that will help, but it might.

(Adam Cole) #3

@Philip_Garrett_Appsh Just tried that and it didn’t work. Also tried using the excel column call out i.e. $A:$A instead of the table column name and it still doesn’t work.