Boolean in multiple sheets

Ask for Help
1

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!

2

What do you mean by “automatically”? Do you mean on the same row in a specific column?

3

Easy :slight_smile: … 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
1 Like
4

Sheet A
Job Completed (yes/no)

Selection in Sheet A should auto apply to Sheet B

Sheet B
Job Completed [yes/no]

5

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?

6

You should do a relation like what Mark said above, using the Job ID (or something unique), then return the boolean via a lookup.

1 Like
7

No! that would create the wrong kind of relationship :slight_smile: :slight_smile:

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).

2 Likes