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

SUMIF >> Value not showing

Posted on 02-05-2022 07:00 AM
maxmaxmax222
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

Why SUMIF Formula doesn't work? I used SUMIF formula before with my other google sheet and there are no problem but this time the value is not showing even through I put correct SUMIF formula.

Does anyone know the reason? Thank you in advance 

maxmaxmax222_0-1644072902371.png

maxmaxmax222_1-1644072919355.png

Check formula by manual, the formula is OK but when apply to appsheet, it doesn't work

maxmaxmax222_0-1644074852514.png

 

 

0 4 338
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Is that an formula you entered into AppSheet?  The formula is not in the R1C1 format which AppSheet requires.

 

Spreadsheet Formulas can be a very powerful companion to App Formulas in AppSheet.  But unless you have a specific need to use the Spreadsheet Formula, I would recommend entering the new formula as an expression in the App Formula property.  You will get more performant responses from an App Formula as they as executed on the device.  Spreadsheet Formulas execute on the sheet.

 

Here is some light reading on SpreadSheet Formulas, I'm not kidding, it is very light but mainly because, as far as I know, they are not commonly used:

https://help.appsheet.com/en/articles/3326638-mismatched-spreadsheet-formulas

https://help.appsheet.com/en/articles/961393-spreadsheet-formulas

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

 

Posted on --/--/---- --:-- AM
maxmaxmax222
Bronze 5
Bronze 5
In response to WillowMobileSys
Reply posted on --/--/---- --:-- AM

Still not working even through I have changed formula format.

maxmaxmax222_0-1644119294769.png

 

0 Likes

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
In response to maxmaxmax222
Reply posted on --/--/---- --:-- AM

I rarely use R1C1 form.  I notice you have "RC[-7]". Is that allowed?

Is there a reason you need to perform the Sum on the sheet?  

There are some Google Sheet formulas not supported by AppSheet because they do not translate well into columular form.  I think there is an article on which function are or are not supported.

While I'm proficient in sheet formulas, I never use them in AppSheet. How they get translated is a bit of mystery to me.

0 Likes

Posted on --/--/---- --:-- AM
WillowMobileSys
Platinum 1
Platinum 1
In response to WillowMobileSys
Reply posted on --/--/---- --:-- AM

Here is the article I was referring to.  It explains the process a bit and why these Google functions cannot be used.  I don't think it impacts your use case however.

https://help.appsheet.com/en/articles/2926968-issues-with-google-sheets-formulas

 

0 Likes
Top Labels in this Space