# Google sheets - get row ID where value is

**URL:** https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849
**Category:** Questions about Thunkable X
**Tags:** beginner, spreadsheets
**Created:** [August 9, 2021, 6:05am UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849 "2021-08-09T06:05:48Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![ondracehak1](https://avatars.discourse-cdn.com/v4/letter/o/58f4c7/32.png) [@ondracehak1](https://community.thunkable.com/u/ondracehak1)
#### Post date: [August 9, 2021, 6:05am UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849/1 "2021-08-09T06:05:48Z")

</div>

Hi! I really need your help 🙂 i dont know how get id of row, where is specific value. I am using google spreadaheet

Example:

## My\_id | Value

6283 | yes  
2891 | Yes  
3728 | Yes

And now, i want to change row with My\_id = 2891 to value “no”. But i cant do that, because there is no any function, to change value of “my\_id” row, just origin row ID . Do anybody know, how to get row ID , if i know “my\_ID” ? Thank you so much 🙂

---

<div class="post-metadata">

### Author: ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [August 9, 2021, 7:56am UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849/2 "2021-08-09T07:56:55Z")

</div>

There is NO ready block for that. You need to create your own function or use it through the DVL (Data Viewer List).

---

<div class="post-metadata">

### Author: ![Hayder](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/hayder/32/153829_2.png) [@Hayder](https://community.thunkable.com/u/Hayder)
#### Post date: [September 11, 2021, 5:46pm UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849/3 "2021-09-11T17:46:52Z")

</div>

> [@ondracehak1](#):
>
> how to get row ID

Hello buddy!  
There are many workarounds that make you get the row ID. Would you explain more what are you going to do so we can help you with more details.

My regards  
Hayder

---

<div class="post-metadata">

### Author: ![codeswept](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/codeswept/32/87755_2.png) [@codeswept](https://community.thunkable.com/u/codeswept)
#### Post date: [September 12, 2021, 7:00am UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849/4 "2021-09-12T07:00:36Z")

</div>

Here you go:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/f/4f8a6f5d9af2cc6ebdd18ed0148d4e2fd113daf0.png)

[https://x.thunkable.com/copy/8523cc5127967563a1a957ad30c29f9b](https://x.thunkable.com/copy/8523cc5127967563a1a957ad30c29f9b)

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:17pm UTC](https://community.thunkable.com/t/google-sheets-get-row-id-where-value-is/1438849/5 "2024-11-08T13:17:30Z")

</div>