# How to reset all items status to back to "Available"? **URL:** \ **Category:** Ask for Help\ **Created:** [November 19, 2023, 1:29pm UTC](https://community.glideapps.com/t/how-to-reset-all-items-status-to-back-to-available/67948 "2023-11-19T13:29:55Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![matt45](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt45/32/58759_2.png) [@matt45](https://community.glideapps.com/u/matt45)\ **Post date:** [November 19, 2023, 1:29pm UTC](https://community.glideapps.com/t/how-to-reset-all-items-status-to-back-to-available/67948/1 "2023-11-19T13:29:55Z")
There just something about this one that seems simple enough but its throwing me for a loop! Let’s say I have 10 items that are visible to all users and available for them to select. Then when a user selects an item is removed from the batch and only 9 are visible. That’s easy enough, Set Column Value, Filters, and voila. BUT when the tenth item is chosen I want to make all 10 items again. That’s where I am getting stuck. I don’t know if my answer is to use a boolean, Increment, or what. My current attempt is as follows: 1. All items have the status of “Available” 2. When an item is selected by a user I use an action to set column value to change the status to “Unavailable” 3. A ITE column spits out a 1 for “Available” and then a 0 for “Unavailable”. 4. A rollup column sums up the ITE column. 5. In the action that sets the column value I have a condition, if the rollup column is \> 1 then it sets column value as “Unavailable”, but if the rollup is less than or equal to 1 it sets column value to “Available”. The logic behind this is that a rollup value of 1 indicates it is the last item available and once that is selected then all the items should become available again. Thus resetting the status back to Available. This works except set column value only changes the status of that singular item. So my question is 1) is the even the approach you’d recommend? 2) if so how would you go about resetting all the values back to “Available” after the final item is selected? I’ve skimmed this [post](https://community.glideapps.com/t/set-all-values-in-a-column-at-the-push-of-a-button/58777/4) to see if there were any obvious helps, nothing leapt out at me, but if so then point me back that way. Thanks! ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [November 19, 2023, 1:47pm UTC](https://community.glideapps.com/t/how-to-reset-all-items-status-to-back-to-available/67948/2 "2023-11-19T13:47:37Z")
One way is with a bit of smoke and mirrors. > [@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… ---
**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:** [November 20, 2023, 3:13am UTC](https://community.glideapps.com/t/how-to-reset-all-items-status-to-back-to-available/67948/3 "2023-11-20T03:13:25Z")
> [@Eric\_Penn](#): > > One way is with a bit of smoke and mirrors. And another way is with Call API and the Glide API 🙂