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 throug…

Here it is : https://docs.google.com/spreadsheets/d/1Ph4_8lscXtY_tYCfn9COOF1ZXR3JsU4CeDwc_mzbEYs/edit?usp=sharing

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.

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.

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

[image] Pratik_Shah: various columns in GlideTables thank you, are you talking about this thing : Glide Docs ? thanks

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 …

You can use Glides inbuilt IF THEN ELSE column to achieve your results as mentioned by @Jeff_Hager

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 f…

You can surely achieve this by creating new Columns with IF THEN ELSE based on above conditions in Glide Editor.

[image] Pratik_Shah: IF THEN ELSE All right i’ll try this one : Glide Docs thanks !

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

IFS conditions

Ask for Help

ThinhDinh October 12, 2020, 10:03am 20

Here’s my tutorial on how to use Arrayformula.

Topic		Replies	Views
Sheet formula Ask for Help	26	839	July 27, 2022
Impossible to Ask for Help	6	327	January 11, 2021
Add new row is clearing my Google Sheet formula Ask for Help	5	811	September 3, 2021
How do you add functions to rows you add with glide? Ask for Help	5	2409	October 5, 2020
Rows in google spreadsheet not increasing Ask for Help	12	301	September 26, 2021

IFS conditions

Related topics