# Boolean in multiple sheets
**URL:** https://community.glideapps.com/t/boolean-in-multiple-sheets/26267
**Category:** Ask for Help
**Created:** [May 1, 2021, 11:34am UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267 "2021-05-01T11:34:09Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@kahakun](https://community.glideapps.com/u/kahakun)
#### Post date: [May 1, 2021, 11:34am UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/1 "2021-05-01T11:34:09Z")
I am looking to make the value condition of Sheet A Boolean value “True/False” for example to automatically apply to Sheet B…
What are the correct steps to this? I tried playing around with no luck!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 1, 2021, 11:58am UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/2 "2021-05-01T11:58:31Z")
What do you mean by “automatically”? Do you mean on the same row in a specific column?
---
### Author:  [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)
#### Post date: [May 1, 2021, 12:02pm UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/3 "2021-05-01T12:02:45Z")
Easy 🙂 … first you need a rel between the sheets)
Let’s say you have in Sheet A a column called 'IsHamster?" - boolean so yes/no
So in Sheet B
- lookup column - lookup through the rel to Sheet A to IsHamster? – it will display as true/false/empty but function like a boolean
---
### Author:  [@kahakun](https://community.glideapps.com/u/kahakun)
#### Post date: [May 1, 2021, 12:34pm UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/4 "2021-05-01T12:34:42Z")
Sheet A
Job Completed (yes/no)
Selection in Sheet A should auto apply to Sheet B
Sheet B
Job Completed [yes/no]
---
### Author:  [@kahakun](https://community.glideapps.com/u/kahakun)
#### Post date: [May 1, 2021, 12:36pm UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/5 "2021-05-01T12:36:48Z")
**I’m having trouble figuring it out…**
Sheet A
Job Completed (yes/no)
Selection in Sheet A should auto apply to Sheet B
Sheet B
Job Completed [yes/no]
Rel Column X to X in sheet A or B?
Lookup in sheet B correct?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [May 1, 2021, 12:40pm UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/6 "2021-05-01T12:40:36Z")
You should do a relation like what Mark said above, using the Job ID (or something unique), then return the boolean via a lookup.
---
### Author:  [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)
#### Post date: [May 1, 2021, 12:40pm UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/7 "2021-05-01T12:40:57Z")
No! that would create the wrong kind of relationship 🙂 🙂
You either need to have a common column between each sheet, OR you create a template column in both sheets, just for the purpose of making rel columns (I use tp-link as a template column with the value ‘link’ ands then use make rel’s based on the link columns).
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/boolean-in-multiple-sheets/26267/8 "2024-01-17T16:52:31Z")