This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

appsheet shows #value for my spreadsheet formula

Posted on 07-20-2023 05:18 AM
SyM_Delarbel
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi. I have the following 2 formulas in my xl sheet: 

=SUMIF(Citas!$D:$D,Clientes!C2,Citas!$AI:$AI)

=SUMIF(Citas!$B:$B,Contabilidad!A2,Citas!$AH:$AH)

Both of them are working well in the xl sheet, but on the AppSheet the first one works well, but the second one returns #VALUE.

Could anyone help me with that issue?

0 2 99
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Tommy62
Bronze 4
Bronze 4
Reply posted on --/--/---- --:-- AM

Wie lauten deine AppSheet Ausdrรผcke dafรผr???

0 Likes

Posted on --/--/---- --:-- AM
SyM_Delarbel
Bronze 1
Bronze 1
In response to Tommy62
Reply posted on --/--/---- --:-- AM

For the first one, the one working well in AppSheet, this is the generated expression : SUMIF(Citas!C4:C4,Clientes!RC[-15],Citas!C35:C35)

For the second one, The one that returns #VALUE, this is the generated expression : SUMIF(Citas!C2:C2,Contabilidad!RC[-1],Citas!C34:C34)

0 Likes