# Thunkable and spreadsheet with formula

**URL:** https://community.thunkable.com/t/thunkable-and-spreadsheet-with-formula/2177610
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [December 13, 2022, 11:56am UTC](https://community.thunkable.com/t/thunkable-and-spreadsheet-with-formula/2177610 "2022-12-13T11:56:16Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![anastasi.fr6w](https://avatars.discourse-cdn.com/v4/letter/a/df705f/32.png) [@anastasi.fr6w](https://community.thunkable.com/u/anastasi.fr6w)
#### Post date: [December 13, 2022, 11:56am UTC](https://community.thunkable.com/t/thunkable-and-spreadsheet-with-formula/2177610/1 "2022-12-13T11:56:16Z")

</div>

Hello,  
i have a spreadsheet connected with thunkable.  
This Spreadsheet has header on first row and formula(cell E2) on second row.  
Formula, on cell E2, is obtained combining data from cells on second row, and these data arrive from thunkable app. After i have to get the output value inside cell E2 and send it to thunkable.

 ![issue](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/6/86da2f8674feeeb7d808fbc8edf7666f0885be20.png)

If i use update it works perfectly. But my question/problem is: if two people, almost simultaneously, try to use it maybe it could be give a synchronazing problem.  
I thought to copy formula(E2) on all the column and use a create row in order to give, to different users, different output but extending formula it creates 0,0 output before data arrives and command crete row occupies an empty line without formula.  
How can i solve this problem?

Thank to all in advance

---

<div class="post-metadata">

### Author: ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)
#### Post date: [December 13, 2022, 1:53pm UTC](https://community.thunkable.com/t/thunkable-and-spreadsheet-with-formula/2177610/2 "2022-12-13T13:53:55Z")

</div>

Sounds like you need a database and not a spreadsheet. Using a back end like xano might be a good starting point for your project.

Spreadsheets with formulas are not meant to be used on apps that have multiple users… The issue you’re talking about with con currency of users is absolutely real, and will be detrimental to the functioning of your app. Should it ever start to have more than just you using it.

Additionally, you should consider doing some of that formula work client side if possible

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)
#### Post date: [March 13, 2023, 1:54pm UTC](https://community.thunkable.com/t/thunkable-and-spreadsheet-with-formula/2177610/3 "2023-03-13T13:54:49Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.