# Help with a formula (likely going to be in Sheets)

**URL:** <https://community.glideapps.com/t/help-with-a-formula-likely-going-to-be-in-sheets/18015>\
**Category:** Ask for Help\
**Created:** [November 5, 2020, 5:54pm UTC](https://community.glideapps.com/t/help-with-a-formula-likely-going-to-be-in-sheets/18015 "2020-11-05T17:54:13Z")\
**Posts on this page:** 1\
**Showing post:** 40

<div class="post-metadata">

**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:** [November 18, 2020, 1:15am UTC](https://community.glideapps.com/t/help-with-a-formula-likely-going-to-be-in-sheets/18015/40 "2020-11-18T01:15:15Z")

</div>

I did, but then I posted something in the Actions thread about the clear action happening before the values are passed to the form screen. I see it as a bug, but it might just be the way it currently works.

> [@new Actions! zapzapzap](https://community.glideapps.com/t/actions/18026/257):
>
> Posting this here as it’s actions-related. I don’t think this is necessarily a bug… maybe more of a feature request. The issue is that I want column values to get pushed to a form, then clear the original choice component after the form button is pressed. Currently, the show form action and clear column action happen at the same time, which clears the column values (resulting in blank columns once the form is submitted). If the Add Row action could include Column Values, that would fix this too …

Edit: I think I see what you’re saying now… compare the last submitted a form value to the choice component and if they match, clear the column. This would have to happen the form submit though, which can’t have actions tied to it yet. The “after form submit” action is a much needed addition to really round out the new Actions!

---

_[View the full topic](https://community.glideapps.com/t/help-with-a-formula-likely-going-to-be-in-sheets/18015)._