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)).
Could you try eliminating the hyphen in โSub-Categoryโ?
I am not sure if that will help, but it might.
@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.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |