# Google sheet and blank value in cell with ODK form data transfer

**URL:** <https://forum.getodk.org/t/google-sheet-and-blank-value-in-cell-with-odk-form-data-transfer/33420>\
**Category:** Support\
**Tags:** google-sheets\
**Created:** [May 4, 2021, 2:40pm UTC](https://forum.getodk.org/t/google-sheet-and-blank-value-in-cell-with-odk-form-data-transfer/33420 "2021-05-04T14:40:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michel\_G](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/michel_g/32/15307_2.png) [@Michel\_G](https://forum.getodk.org/u/Michel_G)\
**Post date:** [May 4, 2021, 2:40pm UTC](https://forum.getodk.org/t/google-sheet-and-blank-value-in-cell-with-odk-form-data-transfer/33420/1 "2021-05-04T14:40:26Z")

</div>

Hello,

I am really glad to find the ODK forum, I discovered ODK last month and I really enjoy it.  
I encountered a bug which seem to be know by the ODK community but not really solve.  
I have sheet of a googlesheet where I send data from ODK forms, and I have blank values which inteferes with formulas in certains columns for each sending of a new form.  
For exemple, I have 15 columns where datas from ODK form are stored, and the newt columns, I have automatic formulas supposed to use datas from ODK.Eah time I send a new form with datas, formulas make the error REF!,and when i click on the cell, I notes that there is an undesirable space which has been send by ODK form.  
Peraphs another users of ODK have meet the same matter, so I will be very glad to know if they succed to solve this bug.

I tried to use TRIM function into cell but it doesnt work and I wonder how I can fix the matter ?

---

<div class="post-metadata">

**Author:** ![Grzesiek2010](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/grzesiek2010/32/2881_2.png) [@Grzesiek2010](https://forum.getodk.org/u/Grzesiek2010)\
**Post date:** [May 5, 2021, 6:22am UTC](https://forum.getodk.org/t/google-sheet-and-blank-value-in-cell-with-odk-form-data-transfer/33420/2 "2021-05-05T06:22:29Z")

</div>

Hi @Michel_G  
We're glad you're here. When you get a chance, please [introduce yourself on this forum thread](https://forum.getodk.org/t/-/6671).

are you talking about blank values in empty cells (without answers)?