# Is there an arrayformula alternative in Appglide Data? **URL:** \ **Category:** Ask for Help\ **Created:** [August 5, 2020, 1:04pm UTC](https://community.glideapps.com/t/is-there-an-arrayformula-alternative-in-appglide-data/13596 "2020-08-05T13:04:12Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Judith\_Golan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/judith_golan/32/86_2.png) [@Judith\_Golan](https://community.glideapps.com/u/Judith_Golan)\ **Post date:** [August 5, 2020, 1:04pm UTC](https://community.glideapps.com/t/is-there-an-arrayformula-alternative-in-appglide-data/13596/1 "2020-08-05T13:04:12Z")
Hi all, I have the following problem: On the app I am working on, there is a list of stones ⛰ with 5 parameters for each one. i.e. Granit Stone: 1. hard, 2. not crumbling, 3. not sparkling, 4. no pulp 5. white/reddish color I collect user specific data input for each stone with its 5 different parameters based on the student impression. In parallel, I have in google sheet an arrayformula for the 5 correct parameters characterizing each stone. I want to compare (probably with an if condition) the arrayformula of each stone to the input from the student and see whether the student impressions fits the actual stone characteristics. The problem is that I don’t know how to create an arrayformula within the data table of appglide, based on the 5 parameters user-specific input. These user specific data don’t appear in the googlesheet, but only in appglide data. Do you have any idea on how I can overcome this so i can do the comparison within Gsheet only or appglide only or even combining both? ![Screenshot_1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f4209bc434ae564598f4073a8d688be0884f1e8f.png) ![Screenshot_2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a9506ea2672146730fe0e04ba997ae4ec358c2e9.png) Judith ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 5, 2020, 1:12pm UTC](https://community.glideapps.com/t/is-there-an-arrayformula-alternative-in-appglide-data/13596/2 "2020-08-05T13:12:06Z")
You can create a series of If Then columns to check each condition and return true or false. Then you can create a final if then column to compare all the true false values and return a final result. It will probably require several columns instead of a single one in your case. ---
**Author:** ![Judith\_Golan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/judith_golan/32/86_2.png) [@Judith\_Golan](https://community.glideapps.com/u/Judith_Golan)\ **Post date:** [August 6, 2020, 8:26am UTC](https://community.glideapps.com/t/is-there-an-arrayformula-alternative-in-appglide-data/13596/3 "2020-08-06T08:26:55Z")
Thanks @Jeff_Hager. > [@Jeff\_Hager](#): > > Then you can create a final if then column to compare all the true false values and return a final result. The thing is I need a nested IF and I didn’t find the way to aggregate all the if conditions so I can finally end up with 2 cells that I am comparing with the “if -then-else glideapps column”. How would you compare all the true false multiple values of a **row** in appglide? I may have to produce somehow a comparison within glideapps data that says: If (user-specific-column.stone\_color AND user-specific-column.stone\_hardness AND user-specific-column.stone\_pulpiness etc…) is equal to (stone\_color AND stone\_hardness AND stone\_pulpiness etc…) then its TRUE. but how? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [August 6, 2020, 11:58am UTC](https://community.glideapps.com/t/is-there-an-arrayformula-alternative-in-appglide-data/13596/4 "2020-08-06T11:58:34Z")
OK, you may not need the multiple if then columns, but you can do multiple if’s in one column. You just need to structure it a little different. Do each compare checking if each condition does but match. If it does not, then return false. The first non match will return False. If everything matches, then it returns True. Like this: ![Screenshot_20200806-065601](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e1d9274b7a5428e6cc811d54ff4b79158a9b4390.png) > [@Judith\_Golan](#): > > If (user-specific-column.stone\_color AND user-specific-column.stone\_hardness AND user-specific-column.stone\_pulpiness etc…) is equal to (stone\_color AND stone\_hardness AND stone\_pulpiness etc…) then its TRUE. If you wanted to do a compare like this, you can easily do this with template columns and then compare the two template columns. ---
**Author:** ![Judith\_Golan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/judith_golan/32/86_2.png) [@Judith\_Golan](https://community.glideapps.com/u/Judith_Golan)\ **Post date:** [August 10, 2020, 6:17am UTC](https://community.glideapps.com/t/is-there-an-arrayformula-alternative-in-appglide-data/13596/5 "2020-08-10T06:17:23Z")
Thanks a lot Jeff. Finally I made an IF column for each parameter in order to translate it to binaric 0 or 1 according to the answer correctness and then added a math column which summed all these binaric new IF columns. I had also a summary IF column checking whether the result in the math column equals 5 (for the 5 parameters) then TRUE, otherwise FALSE. Now that I read again your answer, it seems much shorter. Have to try it.