Worksheet Conditional Formatting Help

[Tom Klaber]

I am trying to set up a homemade issue managing drawing list.  The built-in one is too finicky.  

 

So - I have created Sheet Data boolean fields - ISSUE 1, ISSUE 2, etc.

 

Now I am trying to create a sheet list, and I want to automatically show an ● if that issue is True.

 

VW's built in sheet uses: 

=IF('Title Block Issue Data-1'.'Number'<>'', '●', '')

to do the same thing that references the built issue manager.

 

I am trying to modify it to reference my boolean Issues, but I can not get it to work.

 

Here is what I have:

=IF('Title Block Sheet Data'.'ISSUE 1'.'True', '●', '')

 

Can anybody see what I am doing wrong?

 

Is boolean the wrong thing to use here?

 

[michaelk]

It's easier than that.  

 

If the field is really a boolean field and not a text field that says either "TRUE" or "FALSE":

 

Select one of the fields in the boolean column > Right Click > Format Cells… > Number Tab > Check Boolean on the left side > On the right side enter the values you want displayed for true and false.

[Tom Klaber]

So much easier.

Duh.

Thank you!