How to change true/false to Yes/no from custom document property?

%3CLINGO-SUB%20id%3D%22lingo-sub-1675507%22%20slang%3D%22en-US%22%3EHow%20to%20change%20true%2Ffalse%20to%20Yes%2Fno%20from%20custom%20document%20property%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1675507%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20toggle%20(Yes%2FNo)%20field%20in%20a%20SharePoint%20document%20library.%20When%20I%20tried%20to%20use%20this%20toggle%20field%20on%20Word%20template%2C%20the%20field%20becomes%20true%2Ffalse%20field.%20I%20would%20like%20to%20have%20Yes%20or%20No%20showing%20on%20the%20document.%20I%20tried%20to%20use%20IF%20formula%2C%20it%20always%20shows%20%22No%22.%20Would%20anyone%20can%20help%20me%20on%20this%3F%3C%2FP%3E%3CP%3EThis%20is%20the%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22lras1202_0-1600291269296.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F218865i17C05989B3358E9D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22lras1202_0-1600291269296.png%22%20alt%3D%22lras1202_0-1600291269296.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a toggle (Yes/No) field in a SharePoint document library. When I tried to use this toggle field on Word template, the field becomes true/false field. I would like to have Yes or No showing on the document. I tried to use IF formula, it always shows "No". Would anyone can help me on this?

This is the formula:

 

lras1202_0-1600291269296.png

 

Thank you so much!

0 Replies