# Sheet formula **URL:** \ **Category:** Ask for Help\ **Created:** [July 26, 2022, 11:25am UTC](https://community.glideapps.com/t/sheet-formula/45254 "2022-07-26T11:25:06Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 11:25am UTC](https://community.glideapps.com/t/sheet-formula/45254/1 "2022-07-26T11:25:06Z")
Guys need your advise please How to create a formal on single row sheet need to copy the single row on glide when action happened without any triggers would be appreciate if anyone get back to me ASAP as this am urgent I’m happy to pay for the service Thanks in advanced-)) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 12:10pm UTC](https://community.glideapps.com/t/sheet-formula/45254/2 "2022-07-26T12:10:07Z")
You can Zoom me… [![hire us zoom](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d17fed737198a12015df009c6442ca0c53da9212.png)](https://buy.stripe.com/eVa8Aj7hV8GNeCQcMX) ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 12:29pm UTC](https://community.glideapps.com/t/sheet-formula/45254/3 "2022-07-26T12:29:49Z")
Hiya thanks for the quick reply here is a screenshot ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f7fef8788cb64d91b377776cca9546943710fcc3.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 12:31pm UTC](https://community.glideapps.com/t/sheet-formula/45254/4 "2022-07-26T12:31:06Z")
what exactly you wanna do? copy Email Required to email required? ? which is in google sheets? Zoom 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 26, 2022, 12:38pm UTC](https://community.glideapps.com/t/sheet-formula/45254/5 "2022-07-26T12:38:53Z")
If you want to replicate the logic in the Sheet, you can convert the if-then-else logic to an 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:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 12:41pm UTC](https://community.glideapps.com/t/sheet-formula/45254/6 "2022-07-26T12:41:39Z")
he needs to write that logic in the GS without trigger ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 12:47pm UTC](https://community.glideapps.com/t/sheet-formula/45254/7 "2022-07-26T12:47:18Z")
Hi again Need the action on and off exactly the same which is stated on screenshot Regards ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 12:54pm UTC](https://community.glideapps.com/t/sheet-formula/45254/8 "2022-07-26T12:54:45Z")
hard to understand what you mean… - what that action will be? - how are you getting feed for IF-ELSE column - is the other column in GS? … lets Zoom ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 1:04pm UTC](https://community.glideapps.com/t/sheet-formula/45254/9 "2022-07-26T13:04:09Z")
Hi this is an automated email When it goes (on) on the sheet email sent All what I need when if then else goes off or on need to be on the email required sheet If that possible? Regards ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 1:05pm UTC](https://community.glideapps.com/t/sheet-formula/45254/10 "2022-07-26T13:05:44Z")
yes, with a little help from a simple script… not possible in Glide > **[Email Center Demo](https://email-center-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AZQBtAGEAaQBsACAAYgB1AHQAdABvAG4AIgAsACIAcgAiADoAIgBNADIAcwBuAC4AYQBhAFoAUgBBAE8AcABFAGMAUABmAE8AcwBOAFMAVABnACIAfQA=)** > > create a customized, automatic email responses ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 1:09pm UTC](https://community.glideapps.com/t/sheet-formula/45254/11 "2022-07-26T13:09:34Z")
So you need me to buy this template? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 1:10pm UTC](https://community.glideapps.com/t/sheet-formula/45254/12 "2022-07-26T13:10:10Z")
no, we can Zoom… and i can create a custom script for you… you can try that demo before ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 1:12pm UTC](https://community.glideapps.com/t/sheet-formula/45254/13 "2022-07-26T13:12:04Z")
Ok and is 100% works? And how much will cost? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 1:13pm UTC](https://community.glideapps.com/t/sheet-formula/45254/14 "2022-07-26T13:13:10Z")
try it… you can find out if it works 😉 depends on what you really need… that I will only know after talking to you… if you like what you see in that demo… just buy it… if you need more customization… I can make a specific script ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 1:14pm UTC](https://community.glideapps.com/t/sheet-formula/45254/15 "2022-07-26T13:14:27Z")
Ok how much would that cost? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 1:16pm UTC](https://community.glideapps.com/t/sheet-formula/45254/16 "2022-07-26T13:16:40Z")
i need to know what exactly you need… my prize is $55/hour ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 1:18pm UTC](https://community.glideapps.com/t/sheet-formula/45254/17 "2022-07-26T13:18:06Z")
I told what I need thoughts And if possible can you quote me a fix price Thanks for the understanding ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 1:20pm UTC](https://community.glideapps.com/t/sheet-formula/45254/18 "2022-07-26T13:20:13Z")
no, you did not specify yet… all I know is that you need to send an email when the column value change. please try that demo, you will have much better idea ---
**Author:** ![carlitosuk5](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@carlitosuk5](https://community.glideapps.com/u/carlitosuk5)\ **Post date:** [July 26, 2022, 1:26pm UTC](https://community.glideapps.com/t/sheet-formula/45254/19 "2022-07-26T13:26:14Z")
Hi Which demo? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [July 26, 2022, 1:27pm UTC](https://community.glideapps.com/t/sheet-formula/45254/20 "2022-07-26T13:27:27Z")
> **[Email Center Demo](https://email-center-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AZQBtAGEAaQBsACAAYgB1AHQAdABvAG4AIgAsACIAcgAiADoAIgBNADIAcwBuAC4AYQBhAFoAUgBBAE8AcABFAGMAUABmAE8AcwBOAFMAVABnACIAfQA=)** > > create a customized, automatic email responses it is one of mine best selers… it takes 3 days to make it… if you are a pro [Next page](https://community.glideapps.com/t/sheet-formula/45254.md?page=2)