# Trouble getting the Choice column to write to the correct row of a spreadsheet **URL:** \ **Category:** Ask for Help\ **Created:** [August 7, 2021, 6:09pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157 "2021-08-07T18:09:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![ada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ada/32/29192_2.png) [@ada](https://community.glideapps.com/u/ada)\ **Post date:** [August 7, 2021, 6:09pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/1 "2021-08-07T18:09:17Z")
Hey everyone! This _might_ be a bug, but I’m more inclined to think that I’m having a massive brain fog moment. I have a choice field. When the user selects one of two choices (client or coach), the selected choice should write to that user’s User Type column in Google Sheets/Glide. Unfortunately, that’s not happening–in fact, nothing happens at all. **Edit:** actually, on closer examination, the Choice column _is_ writing to the spreadsheet–it’s only that it’s writing to the very first row/user, not to the current user. [Here’s a Loom video showing what I mean](https://www.loom.com/share/8a4ddfb2386f409caa038fa396ade1a3). For posterity, here’s a screenshot of my original configuration (as @Uzo and @Mark_Turrell pointed out, I was originally writing to the same column as the source of the data). (upload://tJrR457pRdi5PevM3N1cjONAljX.jpeg) ![Screen Shot 2021-08-07 at 2.02.31 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/9/e9587b8ec7872b63908eb6bc5d1a0a63f10f6c68.png) ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [August 7, 2021, 6:24pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/2 "2021-08-07T18:24:58Z")
Normally I’d have: 1. a lookup sheet (usually in Google Sheets / GS) 2. a column for your choice options in the Lookups 3. I use the Lookup sheet as the Source, and pick up values from that column 4. the the ux for the choice component, you wrote the data to your ‘User Type’ column I hope this helps 🙂 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [August 7, 2021, 6:41pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/3 "2021-08-07T18:41:55Z")
from what i see in the picture, you are writing data to the same column as a source of the data… this is why there is no change ---
**Author:** ![ada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ada/32/29192_2.png) [@ada](https://community.glideapps.com/u/ada)\ **Post date:** [August 7, 2021, 7:02pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/4 "2021-08-07T19:02:46Z")
@Uzo @Mark_Turrell Thank you both for the insight! You’re both correct, but I’m still seeing a strange issue occur. So, update: I was originally incorrect, and the Choice column _is_ writing to the User Type column–however, it’s writing to the very first row, not the current user’s row. [Here’s a Loom video showing what I mean](https://www.loom.com/share/8a4ddfb2386f409caa038fa396ade1a3). Do you have any ideas? ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [August 7, 2021, 7:12pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/5 "2021-08-07T19:12:30Z")
Filter the screen by signed-in user. ---
**Author:** ![ada](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ada/32/29192_2.png) [@ada](https://community.glideapps.com/u/ada)\ **Post date:** [August 7, 2021, 7:16pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/6 "2021-08-07T19:16:27Z")
Aaahhhh, you are completely correct! I knew it was something very simple I was missing. Thanks, @kyleheney ! ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/trouble-getting-the-choice-column-to-write-to-the-correct-row-of-a-spreadsheet/30157/7 "2024-01-17T16:51:04Z")