=IF(ISBLANK(F2), COUNTIFS($A$2:$A$12,A2,$E$2:$E$12,“>”&E2)+1,COUNTIFS($A$2:$A$12,A2,$F$2:$F$12,“<”&F2)+1)
It would be a lot easier for someone to help you if you can describe what you’re trying to accomplish in plain language, instead of having people try to decipher your spreadsheet formula.
Here are some expression articles that my help you in the meantime:
https://help.appsheet.com/en/articles/2355953-if
https://help.appsheet.com/en/articles/2355961-ifs
2 Likes
Welcome to the community!
AppSheet is not an equivalent to a spreadsheet. There’s no easy hack; you should really understand how the app works and model your spreadsheet data as a database. The community will help you if you describe your purpose and will guide you through implementing it in the app.
Please start by reading these guides:
1 Like
Hi Thanks,
Basically im developing a games score tracking app.
in that i want points to be updated automatically. so i need a ranking system in order to that. i dont find any solution for ranking the scores in appsheet. based on the rankings i can use if condition to update the points. now i need help how can i do the ranking of different games id.
countif helps in excel but how do i do in this?
Hi Thanks,
Basically im developing a games score tracking app.
in that i want points to be updated automatically. so i need a ranking system in order to that. i dont find any solution for ranking the scores in appsheet. based on the rankings i can use if condition to update the points. now i need help how can i do the ranking of different games id.
countif helps in excel but how do i do in this?
Hi Thanks,
Basically im developing a games score tracking app.
in that i want points to be updated automatically. so i need a ranking system in order to that. i dont find any solution for ranking the scores in appsheet. based on the rankings i can use if condition to update the points. now i need help how can i do the ranking of different games id.
countif helps in excel but how do i do in this???