# Display a field by action by defining the row and column?

**URL:** <https://community.glideapps.com/t/display-a-field-by-action-by-defining-the-row-and-column/76710>\
**Category:** Ask for Help\
**Tags:** data-sync\
**Created:** [September 30, 2024, 10:16am UTC](https://community.glideapps.com/t/display-a-field-by-action-by-defining-the-row-and-column/76710 "2024-09-30T10:16:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevin1/32/90071_2.png) [@Kevin1](https://community.glideapps.com/u/Kevin1)\
**Post date:** [September 30, 2024, 10:16am UTC](https://community.glideapps.com/t/display-a-field-by-action-by-defining-the-row-and-column/76710/1 "2024-09-30T10:16:07Z")

</div>

within an action, if i want to display a specific value of a field by row and column, can i do this? I want to do this to display a google sheets formula total of the added numbers, but within google sheets this will not be in a field of the row of the app entry being edited. Is this what JSON is?.. and if so, how do i make this work? Thanks for any input 👍

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 30, 2024, 2:16pm UTC](https://community.glideapps.com/t/display-a-field-by-action-by-defining-the-row-and-column/76710/2 "2024-09-30T14:16:13Z")

</div>

If you have a way to establish a relation to that other row, then you can use a lookup column to retrieve the value.

You also have the option to use a single value column, which can retrieve a single value from any column in any row of any table.

With, that said, I do have to ask why you are using a google sheet formula? Is this something that could be better served by using a Rollup column?

---

<div class="post-metadata">

**Author:** ![Kevin1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevin1/32/90071_2.png) [@Kevin1](https://community.glideapps.com/u/Kevin1)\
**Post date:** [October 2, 2024, 3:48am UTC](https://community.glideapps.com/t/display-a-field-by-action-by-defining-the-row-and-column/76710/3 "2024-10-02T03:48:07Z")

</div>

Thanks so much Jeff… I am kind of a novice who learns what I need to… when I need to 😉 I am not familiar with Rollup Columns… do you by any chance have a link to get details on this feature… or where on the app dashboard that I find this feature so that I can play around with it?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 2, 2024, 3:58am UTC](https://community.glideapps.com/t/display-a-field-by-action-by-defining-the-row-and-column/76710/4 "2024-10-02T03:58:44Z")

</div>

> **[Rollup Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)**
>
> Perform calculations on columns, such as count, average, and sum.
