# Google sheet formula problem **URL:** \ **Category:** Ask for Help\ **Created:** [May 9, 2024, 9:26am UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215 "2024-05-09T09:26:20Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Post date:** [May 9, 2024, 9:26am UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/1 "2024-05-09T09:26:20Z")
I have some data that is added to a google sheet everyday that includes a signature from the app that is added as a link to the sheet. I’ve applied the image formula to convert that link into an image in the sheet but when i drag the formula down let’s say 10 rows the next data that is added to the google sheet is added to the 11th row. so no matter what type of formula i use, even array formula, as long as is a formula in a row glide sees it as writen row and goes over it. what can i do? kind regards ---
**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:** [May 9, 2024, 10:19am UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/2 "2024-05-09T10:19:47Z")
Question: > [@scotfield123](#): > > I’ve applied the image formula to convert that link into an image in the sheet but when i drag the formula Why do you even need to do that? I mean, if you are displaying the image in Glide, why not just use the URL? ---
**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Post date:** [May 9, 2024, 1:33pm UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/3 "2024-05-09T13:33:49Z")
i’m converting automatically the google sheet to a pdf and email it to client with all the workers signatures when they clock in. I’m sure it is another easier way to do this but I didn’t find it. thank you for your reply ![tttt](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f463b33b753ac9d467e49b3804d61929bf123622.png) ---
**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:** [May 9, 2024, 1:35pm UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/4 "2024-05-09T13:35:49Z")
Which plan are you on? You could generate this inside Glide using one of the PDF integrations - either PDF Monkey or Docs Automater. ---
**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\ **Post date:** [May 9, 2024, 1:40pm UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/5 "2024-05-09T13:40:17Z")
Team plan ---
**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:** [May 9, 2024, 1:53pm UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/6 "2024-05-09T13:53:51Z")
> [@scotfield123](#): > > so no matter what type of formula i use, even array formula, as long as is a formula in a row glide sees it as writen row and goes over it. You nailed it in your comment. Glide won’t touch rows that are populated when adding a new row, even with formulas that don’t return anything. However arrayformulas usually work. They do populate every row in the table, but Glide usually adds a new row at the end of the table and the array formula automatically applies to that new row. Whenever you use array formulas, it’s best to delete all empty rows so you don’t end up with a bunch of empty rows. With that said, I would at least look into the built in Glide integrations to build the PDF that @Darren_Murphy mentioned. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [May 9, 2024, 1:56pm UTC](https://community.glideapps.com/t/google-sheet-formula-problem/73215/7 "2024-05-09T13:56:42Z")
I usually create it in different columns between the URL and the image formula: `=IMAGE(A1)`.