# Single Value updating in Sheet column

**URL:** https://community.glideapps.com/t/single-value-updating-in-sheet-column/19150
**Category:** Ask for Help
**Created:** [November 30, 2020, 4:32pm UTC](https://community.glideapps.com/t/single-value-updating-in-sheet-column/19150 "2020-11-30T16:32:20Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)
#### Post date: [November 30, 2020, 4:32pm UTC](https://community.glideapps.com/t/single-value-updating-in-sheet-column/19150/1 "2020-11-30T16:32:20Z")

</div>

Hi,

I have single value column (Last Feedback) which picks up a Last value from related table. I want the returned value to be updated in my column in sheet (LastStatus).

How do I assign the value from single value sheet column ?  
Request a support, Thanks in advance.

 ![glide 30-11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87b5aa34cdef77ff0dc3cf3431f384dd6be7e2e2.png)

---

<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: [November 30, 2020, 5:09pm UTC](https://community.glideapps.com/t/single-value-updating-in-sheet-column/19150/2 "2020-11-30T17:09:19Z")

</div>

Are you using a form to submit the status? You can now use actions on form submit to write to a column (set columns) in a related sheet through a single relation.

> [@rocket Actions on FORM SUBMISSION!](https://community.glideapps.com/t/actions-on-form-submission/19049):
>
> You can now configure custom actions to occur upon form submission! [https://www.loom.com/embed/a88bd4555db447c6b8e73bb12222b5b7?sid=59a89a8e-57b3-4aa3-aea1-c09fbfbdb20d](https://www.loom.com/embed/a88bd4555db447c6b8e73bb12222b5b7?sid=59a89a8e-57b3-4aa3-aea1-c09fbfbdb20d) https://www.loom.com/share/a88bd4555db447c6b8e73bb12222b5b7

---

<div class="post-metadata">

### Author: ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)
#### Post date: [November 30, 2020, 6:03pm UTC](https://community.glideapps.com/t/single-value-updating-in-sheet-column/19150/3 "2020-11-30T18:03:25Z")

</div>

Thanks Jeff. I am using a form to register a call in “call history”. While adding the record I am collecting responses from the lead through a dropdown. I need the value collected from dropdown to be updated simultaneously in the customer master header table in a column named LastStatus. I tried actions on form, but confusing me. I am sharing my app to get a better idea how it works now and how. Sorry for not able to follow your instructions.

---

<div class="post-metadata">

### Author: ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)
#### Post date: [December 1, 2020, 5:38pm UTC](https://community.glideapps.com/t/single-value-updating-in-sheet-column/19150/4 "2020-12-01T17:38:45Z")

</div>

Hi Jeff  
Is there any way to move formula value to Sheet column value. As shown in the figure above, all what I need is to appear the value in Last FeedBack to LastStatus. Last FeedBack is a formula column which brings the value from a related table.  
Looking forward to hear from you.

Thanks and regards,  
Jay