Hello SharePoint Community!
So, I have a list of a item content type
that has a Yes/No field. I reference this content type in a lookup relationship on a Document Library. From that lookup relationship I want to get the value of the Yes/No field.
Now I know that Choice fields are not allowed as lookup columns. So I created a calculated "single line text" field on the content type that strings out the value of my Yes/No field.
This calculated field works fine and well on the Item list. (If Column is checked the value of the calculated field changes to "Yes")...
Then on my document library when I look at my lookup field related [Additional] columns, I can see and select my work around Yes/No item text field! Awesome!
Problem:
- The value that is shelled out on to the document library is not "Yes" or "No"... It's '1' or '0' respectively.
Which would not bother me really too much, but for number 2...
- The document library filter wont allow me to filter based on my
calculated-related-lookup-column
in any way that makes since.
I tride:
item:col [equal to] {1, 0, "1", "0"}
item:col [equal to] {Yes, YES, yes}
item:col [equal to] {True, TRUE, true}
Using [grater than] or [less than] gives some less than veried results...
I even thought about trying the ASCII integer values...
I am out of ideas. All I really want to do, is be able to filter on my wacky calculated-related-lookup-column
. I don't care that it doesn't actually say Yes or No, but am wondering if that is a symptom to the solution of the problem!
Thanks!