![]() ![]() Remember that arrayformulas work best if there are no empty rows. The “ formulas and explanation” sheet explains the formulas. See Example spreadsheet in example folder. It simply involves using a table with one row and one column as a text box. Another great way to add a text box in Google docs is to use a single-cell table. Create Text box in Google Docs using a Single-Cell table. Then in the second new column put =arrayformula(SPLIT( E:E, ", " )) I used two formulas to keep it simple. A step-by-step guide you may use to easily draw and insert a text box into Google Docs. =arrayformula(if(row( A:A )= 1, "photoid1 photoid2 photoid3 photoid4 photoid5" ,substitute( D:D, "open?", "thumbnail?sz=w500&" ))) If you have allowed multiple images to a question, insert as many columns in the sheet as you allowed images plus one and put this formula in row one of the first new column. If you only have allowed a single image, then this formula will work. (This formula will only work for photos collected using a Google Form. Note - These formulas were written where a comma is the separating operator. ![]() How do you merge images from Google Drive? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |