# Howe to bypass a input so formula can work

**URL:** https://community.thunkable.com/t/howe-to-bypass-a-input-so-formula-can-work/2459061
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [June 9, 2023, 2:04pm UTC](https://community.thunkable.com/t/howe-to-bypass-a-input-so-formula-can-work/2459061 "2023-06-09T14:04:36Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)
#### Post date: [June 9, 2023, 2:04pm UTC](https://community.thunkable.com/t/howe-to-bypass-a-input-so-formula-can-work/2459061/1 "2023-06-09T14:04:36Z")

</div>

I have this formula in row 3 in my google sheet, i got it working now =ArrayFormula(IF(D3:D50495=“”,“”,D3:D50495\*LOOKUP(2,1/(G$2:G\<\>“”),G$2:G)))  
But now how can I get it to work so to bypass the perdag value, if I add a [" "] it makes a empry row, and wton info in next row.

 ![Screenshot_58](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/9/a9e0161a02fb49031e4b76bdacf2b704ed3efca0.png)

---

<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: [June 9, 2023, 2:11pm UTC](https://community.thunkable.com/t/howe-to-bypass-a-input-so-formula-can-work/2459061/2 "2023-06-09T14:11:24Z")

</div>

The values in a `create row` block are cells in columns, not rows. So if you use a blank text string block (“”), it will make the PerDag column value for that row an empty string. The value of the PerDag column/cell should not stop you from creating other rows.

If you are creating rows inside of a loop block, then you are expecting Thunkable to work too fast. The `create row` block takes some time since it’s updating a cloud-based data source. In that case, you need to add a `wait` block after or inside your `create row` block to slow things down. Usually, waiting 0.03 seconds or even 0 seconds will fix it.

---

<div class="post-metadata">

### Author: ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)
#### Post date: [June 9, 2023, 2:49pm UTC](https://community.thunkable.com/t/howe-to-bypass-a-input-so-formula-can-work/2459061/3 "2023-06-09T14:49:34Z")

</div>

Thank you, it is working now

---

<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: [September 7, 2023, 2:49pm UTC](https://community.thunkable.com/t/howe-to-bypass-a-input-so-formula-can-work/2459061/4 "2023-09-07T14:49:45Z")

</div>

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