# Iterate through two google sheets columns at once?

**URL:** <https://community.thunkable.com/t/iterate-through-two-google-sheets-columns-at-once/2992756>\
**Category:** Questions about Thunkable X\
**Tags:** google-sheets\
**Created:** [May 8, 2024, 10:19pm UTC](https://community.thunkable.com/t/iterate-through-two-google-sheets-columns-at-once/2992756 "2024-05-08T22:19:27Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [May 9, 2024, 1:58am UTC](https://community.thunkable.com/t/iterate-through-two-google-sheets-columns-at-once/2992756/4 "2024-05-09T01:58:20Z")

</div>

Okay so would this be another way to say it?

> Display the value of the “Bad” column for the logged in student at the current time (hour)

And then for each other column (“Good”, “Okay”, etc.)?

The way I would do that is to Find the First Occurrence of `app variable Student ID` in column “Student ID” of the data source (that will return the row # with Class Hour “1st”) and then add [current hour minus one] to that value. Use that number as the row id to get the row object from the data source. Then get each property (column name) from the row object.   
  
·····················································································································  
Need help? [How to Ask Great Questions](https://community.thunkable.com/t/how-to-ask-great-questions-v2-0/2689983) ✨ [Debugging A Project](https://community.thunkable.com/t/debugging-in-thunkable-x-video/849471) ✨ [API JSON Tutorial](https://community.thunkable.com/t/api-json-tutorial-video/1140575)

Want to hire a Certified Thunkable Expert? [Elevate your app with Tatiang on Fiverr](https://www.fiverr.com/s/726B4a)

---

_[View the full topic](https://community.thunkable.com/t/iterate-through-two-google-sheets-columns-at-once/2992756)._