# Issue with multiple function formula **URL:** \ **Category:** Ask for Help\ **Created:** [July 22, 2020, 10:24am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925 "2020-07-22T10:24:58Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 10:24am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/1 "2020-07-22T10:24:58Z")
Hi Lovely community, here is the rookie again. I have created an embedded formula in Sheets as such: =IF(ISBLANK(G89),“VACANT”,IF(AND(G89\now()),“OCCUPIED”,“VACANT”)). It works fine. However, I would like to know how to apply it automatically in the whole column in my spreadsheet. So far, everytime I add a new row, I have to copy the form in the cell. Any tips ? ---
**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:** [July 22, 2020, 10:27am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/2 "2020-07-22T10:27:15Z")
I’m assuming you want to apply from row 2, and name the column “StatusCheck”. Apply this to cell G1. `={"StatusCheck";ARRAYFORMULA(IF(ISBLANK(G2:G),“VACANT”,IF((G2:Gnow())=1,“OCCUPIED”,“VACANT”))}` ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 10:38am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/3 "2020-07-22T10:38:12Z")
![Screenshot 2020-07-22 at 12.34.37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/896fead099951920d7f81a9ae7c1b391ee0809a1.png) I am having an error message. Maybe I should paste it in G2. my brain is going spaghetti ---
**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:** [July 22, 2020, 10:38am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/4 "2020-07-22T10:38:51Z")
Are you from a country that uses “;” as delimiter instead of “,” in the formulas? ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 10:39am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/5 "2020-07-22T10:39:40Z")
we use ; indeed ---
**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:** [July 22, 2020, 10:43am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/6 "2020-07-22T10:43:25Z")
From looking at your screenshot, please try this first. The double quotation marks around the “OCCUPIED” and “VACANT” doesn’t look right. Please delete them and make the quotation look like the quotation marks around the StatusCheck. ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 10:54am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/7 "2020-07-22T10:54:21Z")
Hi, I have made the necessary changes but I am having following error message : “The result could not be expanded automatically. Please insert new lines (1)” I have tried in a different spreadsheet so that I do not mess up my app 🙂 ![Screenshot 2020-07-22 at 12.48.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/31dcf08e56d93aff4e01f563816a7cf019d31722.png) ---
**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:** [July 22, 2020, 11:06am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/8 "2020-07-22T11:06:53Z")
Can you try deleting the formula in row 2? What did it return when you only have it in row 1? ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 11:17am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/9 "2020-07-22T11:17:35Z")
just tried. It only applies in first row. I tried to insert a line in between but still nothing. Argh. I am not even half way through my app. ---
**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:** [July 22, 2020, 11:29am UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/10 "2020-07-22T11:29:25Z")
Can you share a copy of that sheet with edit access to [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com)? I will take a look later tonight when I get back to the laptop. ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 12:20pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/11 "2020-07-22T12:20:22Z")
> [@ThinhDinh](#): > > [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com) I just shared it, thank you for your support. Appreciate it. ---
**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:** [July 22, 2020, 1:12pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/12 "2020-07-22T13:12:43Z")
Have you tried to do any of this in the glide data editor, or do you need these values to be in the sheet? ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 1:21pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/13 "2020-07-22T13:21:37Z")
No, I have not tried in data editor directly. how should I do ? I have not entered a formula in data editor so far. If you could teach me that would be great. ---
**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:** [July 22, 2020, 1:25pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/14 "2020-07-22T13:25:10Z")
[https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else](https://docs.glideapps.com/all/reference/data-editor/computed-columns/if-then-else) ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 1:28pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/15 "2020-07-22T13:28:28Z")
you rock, thank you very much. You sorted me out big time ---
**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:** [July 22, 2020, 2:34pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/16 "2020-07-22T14:34:51Z")
I have also fixed the formula in the Sheet you shared with me in case you need it, please have a look. ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 22, 2020, 2:48pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/17 "2020-07-22T14:48:39Z")
Did you already share it with me? ---
**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:** [July 22, 2020, 2:59pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/18 "2020-07-22T14:59:53Z")
I fixed it in the sheet you shared with me. ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 23, 2020, 5:05pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/19 "2020-07-23T17:05:08Z")
Many thanks for your support, it’s perfect ---
**Author:** ![Fanny\_Ditomene\_Sekwe](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fanny_ditomene_sekwe/32/10112_2.png) [@Fanny\_Ditomene\_Sekwe](https://community.glideapps.com/u/Fanny_Ditomene_Sekwe)\ **Post date:** [July 27, 2020, 12:27pm UTC](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925/21 "2020-07-27T12:27:15Z")
Hi, I have tried to set up the same formula in the data editor but the ‘’ if-then-else’’ column only uses 1 column as reference whereas my condition uses data from 2 different columns. [Next page](https://community.glideapps.com/t/issue-with-multiple-function-formula/12925.md?page=2)