Howe to bypass a input so formula can work

Questions about Thunkable
1

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
Screenshot_58788×448 45 KB

2

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.

3

Thank you, it is working now

1 Like
4

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