# Thunkable doesn't function well with the google spreadsheet data source

**URL:** <https://community.thunkable.com/t/thunkable-doesnt-function-well-with-the-google-spreadsheet-data-source/831565>\
**Category:** Questions about Thunkable X\
**Tags:** data-viewer\
**Created:** [September 19, 2020, 7:06pm UTC](https://community.thunkable.com/t/thunkable-doesnt-function-well-with-the-google-spreadsheet-data-source/831565 "2020-09-19T19:06:59Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [September 22, 2020, 4:35am UTC](https://community.thunkable.com/t/thunkable-doesnt-function-well-with-the-google-spreadsheet-data-source/831565/7 "2020-09-22T04:35:27Z")

</div>

> [@Steven](#):
>
> - Are you saying that updating a value in a single cell will cause cells in the same row to convert their formulas to text? If so, that is a huge unintended issue that I was not yet aware of. I can look into fixing that as formulas are one of the main things that enable more advanced usage so we obviously don’t want to be overwriting them.

Yes, that’s exactly what I’m experiencing. I’ll try to make a sample project that shows this. The project I’m working on right now has 2,000+ blocks and it would take me longer to explain everything in that one than it would to make a sample project for you.

I’m curious if it’s restricted to the particular Google Sheet I’m using so it’ll be a good test to set it up with a new Google Sheet and see if I can re-produce it. I may have also been mistakenly trying to create a row… I wasn’t so sure how the update value block worked when I started out: [Sample Google Sheet project? - #2 by tatiang](http://community.thunkable.com/t/sample-google-sheet-project/810485/2).

---

_[View the full topic](https://community.thunkable.com/t/thunkable-doesnt-function-well-with-the-google-spreadsheet-data-source/831565)._
