# How do I make the formula work? **URL:** \ **Category:** Ask for Help\ **Created:** [September 28, 2023, 4:35am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591 "2023-09-28T04:35:48Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [September 28, 2023, 4:35am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/1 "2023-09-28T04:35:48Z")
When adding rows to Google Spreadsheet, I want it to be translated for each column. If you paste, a row is added below and the formula cannot be applied. How do I make the formula work? ![20230928_133519](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fca5c2bad03be5e6b9dd0aa441f4636f01f3d923.png) ---
**Author:** ![Jamessmith0901](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamessmith0901/32/64248_2.png) [@Jamessmith0901](https://community.glideapps.com/u/Jamessmith0901)\ **Post date:** [September 28, 2023, 5:37am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/2 "2023-09-28T05:37:14Z")
> [@\_ffwpu](#): > > When adding rows to Google Spreadsheet, I want it to be translated for each column. > If you paste, a row is added below and the formula cannot be applied. > How do I make the formula work? When adding rows to Google Spreadsheet, I want it to be translated for each column. If you paste, a row is added below and the formula cannot be applied. How do I make the formula work? ---
**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:** [September 29, 2023, 1:13am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/3 "2023-09-29T01:13:39Z")
What formula are you using to translate the words? ---
**Author:** ![\_ffwpu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/_ffwpu/32/16380_2.png) [@\_ffwpu](https://community.glideapps.com/u/_ffwpu)\ **Post date:** [September 29, 2023, 3:15am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/4 "2023-09-29T03:15:08Z")
Translation is done by googletranslate. 2023년 9월 29일 (금) 오전 10:23, Thịnh Đinh via Glide Community \<[notifications@glideapps.discoursemail.com](mailto:notifications@glideapps.discoursemail.com)\>님이 작성: ---
**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:** [September 30, 2023, 2:30am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/5 "2023-09-30T02:30:39Z")
> **[BYROW Function in Google Sheets](https://www.benlcollins.com/spreadsheets/byrow-function/)** > > Learn how to use the BYROW function in Google Sheets, a new lambda helper function that works on arrays row-by-row. Please use the BYROW function to make it work on every row. It would look like. > ={“Translation”;BYROW(A2:A,LAMBDA(x,IF(x=“”,“”,GOOGLETRANSLATE(x,“lang1”,“llang2”))))} ---
**Author:** ![Jamessmith0901](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jamessmith0901/32/64248_2.png) [@Jamessmith0901](https://community.glideapps.com/u/Jamessmith0901)\ **Post date:** [October 9, 2023, 3:05am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/6 "2023-10-09T03:05:46Z")
To apply a formula to new rows in a Google Spreadsheet, use the “fill down” feature. Enter the formula in the first row, then drag the fill handle down to the last row where the formula should be applied. Alternatively, select the entire column and use the keyboard shortcut “Ctrl + D” (Windows) or “Command + D” (Mac) to fill down the formula to all the cells in that column. This will ensure the formula is applied to new rows, translating the data automatically. ---
**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 9, 2023, 3:57am UTC](https://community.glideapps.com/t/how-do-i-make-the-formula-work/66591/7 "2023-10-09T03:57:54Z")
This should not be recommended. Arrayformula/Byrow works best, because if you use the method mentioned, if there are rows beyond the original range, the formula won’t be applied.