# Changing "status" in two separate sheets **URL:** \ **Category:** Ask for Help\ **Created:** [July 12, 2021, 9:34pm UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017 "2021-07-12T21:34:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![jchimp](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jchimp](https://community.glideapps.com/u/jchimp)\ **Post date:** [July 12, 2021, 9:34pm UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/1 "2021-07-12T21:34:31Z")
If you have an “item” that has a status - for example a product. When the product is ordered, this information is added to another sheet called “Orders” and “status” is changed from available to ordered. But how do I keep two cells synced? So for example if I change the product back to available, I would like the status in both sheet columns to change as well. Basically keeping the entry synced. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 12, 2021, 11:33pm UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/2 "2021-07-12T23:33:40Z")
I think what you want is only update the original item’s status, then in the Orders sheet, you make a relation back to the Product table and use a lookup to get the status over, if you want information to appear in both sides. Assuming you’re using a form to do this, the on submit action of the order form would use the relation back to the Products table to set the status to Ordered. Then anytime you make a change to the status in the Products table, it will be updated via the lookup as stated in first paragraph. ---
**Author:** ![jchimp](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jchimp](https://community.glideapps.com/u/jchimp)\ **Post date:** [July 21, 2021, 12:02am UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/3 "2021-07-21T00:02:11Z")
It’s a little tricky because when a user orders that product (using a form), a new line is created in the Orders sheet with details of the product also retrieved automatically from Products page, but I can’t seem to be able to change the status in the first Products sheet… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 21, 2021, 12:04am UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/4 "2021-07-21T00:04:31Z")
If you want to sync, you don’t have to write the status in the form submission. In the Orders sheet, create a relation back to the Products and retrieve the status through a lookup instead. ---
**Author:** ![jchimp](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jchimp](https://community.glideapps.com/u/jchimp)\ **Post date:** [July 21, 2021, 12:06am UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/5 "2021-07-21T00:06:38Z")
Ah yes… but the status on the Products page is originally Available, and when it’s ordered (using form) then it should change to Ordered in both sheets. That’s what I can’t get my head around. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 21, 2021, 12:11am UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/6 "2021-07-21T00:11:39Z")
For the on submit action of the form, can you try using a set column using the relation as I described above, and set the status column to “Ordered”? ---
**Author:** ![jchimp](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jchimp](https://community.glideapps.com/u/jchimp)\ **Post date:** [July 21, 2021, 12:15am UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/7 "2021-07-21T00:15:11Z")
Let me try that. Also, here’s a quick brief of how the app works: - User adds a product (it’s labeled as Available in Products sheet) - When another user orders that product, change the status in the Products to Ordered instead of Available, and add the order details to Orders with the status now updated (synced) to show Ordered as well - Later if product is returned or process doesn’t get through, should be able to change the product back to Available… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 21, 2021, 12:41am UTC](https://community.glideapps.com/t/changing-status-in-two-separate-sheets/29017/8 "2021-07-21T00:41:52Z")
Let’s try that and let us know. We have other ways to try if the method above does not work.