# Clear entire column

**URL:** <https://community.glideapps.com/t/clear-entire-column/49265>\
**Category:** Ask for Help\
**Created:** [September 14, 2022, 12:28am UTC](https://community.glideapps.com/t/clear-entire-column/49265 "2022-09-14T00:28:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\
**Post date:** [September 14, 2022, 12:28am UTC](https://community.glideapps.com/t/clear-entire-column/49265/1 "2022-09-14T00:28:48Z")

</div>

I want to clear an entire number column. I set a button to have an action to clear the column but only the first row is being cleared. What am I doing wrong/what is the proper way to make this work?

Thanks  
Todd

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [September 14, 2022, 12:47am UTC](https://community.glideapps.com/t/clear-entire-column/49265/2 "2022-09-14T00:47:00Z")

</div>

Unfortunately, make this is not possible so far. Your plan B is via a GS script.

A Set Column Action only works with a simple relation and you (we) need to use a multiple relation to get it. It has been a desired feature request for a long time.

Saludos Tood!

---

<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:** [September 14, 2022, 2:04am UTC](https://community.glideapps.com/t/clear-entire-column/49265/3 "2022-09-14T02:04:10Z")

</div>

Here is an alternative approach that you might be able to use.

> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

---

<div class="post-metadata">

**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\
**Post date:** [September 14, 2022, 1:43pm UTC](https://community.glideapps.com/t/clear-entire-column/49265/4 "2022-09-14T13:43:12Z")

</div>

Great information, thank you!

---

<div class="post-metadata">

**Author:** ![Todd\_Lichtenwalter](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/todd_lichtenwalter/32/12231_2.png) [@Todd\_Lichtenwalter](https://community.glideapps.com/u/Todd_Lichtenwalter)\
**Post date:** [September 14, 2022, 1:43pm UTC](https://community.glideapps.com/t/clear-entire-column/49265/5 "2022-09-14T13:43:26Z")

</div>

Excellent, thank you!