# IFS conditions **URL:** \ **Category:** Ask for Help\ **Created:** [October 10, 2020, 9:54am UTC](https://community.glideapps.com/t/ifs-conditions/16985 "2020-10-10T09:54:45Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 10, 2020, 9:54am UTC](https://community.glideapps.com/t/ifs-conditions/16985/1 "2020-10-10T09:54:45Z")
HI there ! I’m using “ifs” function on my gsheet in order to assign people according to a specific category when a new entry is submited. For example : when a new submision including the term “boat”, i want it to be assigned to a specific email adress. However, when a new entry is submited through glide app, the row filled is at the bottom of the gsheet (meaning i have a lot of empty cells between) maybe i’m doing something wrong with the function ? do you have any clue ? thanks Maybe i should check directly on the conditions options through glide ? thanks ! ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [October 10, 2020, 10:23am UTC](https://community.glideapps.com/t/ifs-conditions/16985/2 "2020-10-10T10:23:55Z")
Hey @Alter345, This happens because of the array formula. Somehow Glide takes this as all those rows are used and adds your new rows at the bottom. To solve this, you have to delete all the empty rows. ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [October 10, 2020, 10:50am UTC](https://community.glideapps.com/t/ifs-conditions/16985/3 "2020-10-10T10:50:44Z")
What @SantiagoPerez mentioned is correct. However, instead of using formula in Gsheet, you can use various columns in GlideTables for similar results but with faster results. ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 10, 2020, 1:47pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/4 "2020-10-10T13:47:14Z")
Thanks for your reply, i tried to delete all the empty rows however, if i do that, i cannot put the formula for the new entries ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 10, 2020, 1:53pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/5 "2020-10-10T13:53:13Z")
> [@Pratik\_Shah](#): > > various columns in GlideTables thank you, are you talking about this thing : [Glide Docs](https://docs.glideapps.com/all/reference/data-editor/glide-tables) ? thanks ---
**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:** [October 10, 2020, 1:54pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/6 "2020-10-10T13:54:48Z")
Glide/Google will not touch rows that are already filled, whether it’s an arrayformula or a formula that is populated via the drag down method. Arrayformula’s can work around this because it auto-populates the formula on every row, but because of the above, you have to delete all empty rows so new data isn’t appended to the very bottom of the sheet…after every “empty” but formula filled row. The problem here is I believe IFS is not arrayformula compatable, so you have to start doing some crazy workarounds or introduce scripting into your sheet. Is there any reason you can’t use glide’s built in functions? Or can you explain a little more in depth what you are attempting to do, so we can see if there is a better formula or way to accomplish what you want? ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [October 10, 2020, 2:26pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/7 "2020-10-10T14:26:08Z")
You can use Glides inbuilt IF THEN ELSE column to achieve your results as mentioned by @Jeff_Hager ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 10, 2020, 2:27pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/8 "2020-10-10T14:27:34Z")
Many thanks for your reply ! in fact maybe the IFS cannot work with array formula. I will try to explain what i’m looking to do : - I will create a type form on a web page - on this form, I will ask for name, company and interest (A, B or C let’s say), all linked to glide of course. - When a person fill out the form, when they select “interest A”, i want it to be assigned to a specific email adress (let’s say [a@v.com](mailto:a@v.com)), when a person select “Interest B”, I want it to be assigned to another specific email adress (let’s say [b@v.com](mailto:b@v.com)) etc … - When a form is filled out (through glide app OR type form), i want a new row to be created with the right email adress AND create through zappier or integromat a rule that when a new row is created, send an email to the specific email adress selected. Note : company interest can be : a text value OR maybe number (like when datas are \>100, assign a email adress, \<100 assign to another email adress) I hope you can understand with my english … 😉 thanks ! ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [October 10, 2020, 2:33pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/9 "2020-10-10T14:33:47Z")
You can surely achieve this by creating new Columns with IF THEN ELSE based on above conditions in Glide Editor. ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 10, 2020, 2:49pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/10 "2020-10-10T14:49:45Z")
> [@Pratik\_Shah](#): > > IF THEN ELSE All right i’ll try this one : [Glide Docs](https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else) thanks ! ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 10, 2020, 3:29pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/12 "2020-10-10T15:29:25Z")
The thing with this solution is that column are only display in the glide data menu and not updated on the GSHEET, so i will not be able to send zappier information ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 10, 2020, 4:24pm UTC](https://community.glideapps.com/t/ifs-conditions/16985/13 "2020-10-10T16:24:23Z")
What type of Zap are you trying to configure? If you can set up a sheet with dummy data and the logic you want to achieve we will try to jump in and help. ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 11, 2020, 6:50am UTC](https://community.glideapps.com/t/ifs-conditions/16985/14 "2020-10-11T06:50:22Z")
OK i tried to create a sheet : [https://docs.google.com/spreadsheets/d/1Ph4\_8lscXtY\_tYCfn9COOF1ZXR3JsU4CeDwc\_mzbEYs/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1Ph4_8lscXtY_tYCfn9COOF1ZXR3JsU4CeDwc_mzbEYs/edit?usp=sharing) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 11, 2020, 9:22am UTC](https://community.glideapps.com/t/ifs-conditions/16985/15 "2020-10-11T09:22:22Z")
We can’t access that. ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 12, 2020, 6:10am UTC](https://community.glideapps.com/t/ifs-conditions/16985/16 "2020-10-12T06:10:38Z")
Here it is : [https://docs.google.com/spreadsheets/d/1Ph4\_8lscXtY\_tYCfn9COOF1ZXR3JsU4CeDwc\_mzbEYs/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1Ph4_8lscXtY_tYCfn9COOF1ZXR3JsU4CeDwc_mzbEYs/edit?usp=sharing) ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 12, 2020, 7:11am UTC](https://community.glideapps.com/t/ifs-conditions/16985/17 "2020-10-12T07:11:11Z")
HI, after spending the WE and trying to understand … 😉 Yes there is a reason why I can’t use glide’s built in functions, since i want to send a “notification” to each email owner (i want thinking of doing this by gsheet + zappier). BUt glides functions doesn not populate the gsheet … I tried IF the else function, works well, but i can’t use it with gseet and zappier ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 12, 2020, 9:43am UTC](https://community.glideapps.com/t/ifs-conditions/16985/18 "2020-10-12T09:43:21Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bf763c27a968b7efe189d6fd29f139f5be2cd12d.png) Hi, I have made the needed changes for you. You can use Zapier to trigger sending an email when a new row is added. ---
**Author:** ![Alter345](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@Alter345](https://community.glideapps.com/u/Alter345)\ **Post date:** [October 12, 2020, 9:59am UTC](https://community.glideapps.com/t/ifs-conditions/16985/19 "2020-10-12T09:59:47Z")
WOW ! THANK YOU SO MUCH ! It’s perfect !!! thanks thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 12, 2020, 10:03am UTC](https://community.glideapps.com/t/ifs-conditions/16985/20 "2020-10-12T10:03:56Z")
Here’s my tutorial on how to use Arrayformula. > [@Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts](https://community.glideapps.com/t/tutorial-arrayformula-in-google-sheets-good-practices-how-to-overcome-arrayformula-restrictions-with-scripts/9727): > > Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. > > > **1/ Definition** > > > > Arrayformula is defined as “a range, mathematical expression using one cell range … ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 7, 2024, 2:57am UTC](https://community.glideapps.com/t/ifs-conditions/16985/21 "2024-02-07T02:57:52Z")