Column Formatting using JSON from a Lookup Column

%3CLINGO-SUB%20id%3D%22lingo-sub-1458386%22%20slang%3D%22en-US%22%3EColumn%20Formatting%20using%20JSON%20from%20a%20Lookup%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1458386%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20document%20Library%20where%20one%20of%20my%20Columns%20is%20a%20Lookup%2C%20the%20list%20is%20of%20Project%20Names%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20would%20like%20to%20do%20is%20be%20able%20to%20only%20show%20the%20Project%20Names%20that%20are%20relevant%20to%20the%20Project%20Library%20as%20currently%20the%20list%20shows%20everything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20only%20show%20the%20Project%20Name%20if%20it's%20equal%20or%20contains%20the%20Customer%20Name%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20if%20the%20Format%20Current%20View%20option%20would%20work%20but%20would%20like%20to%20try%20it%20using%20JSON%20if%20possible%20and%20I%20don't%20have%20knowledge%20of%20JSON%20so%20guidance%20of%20how%20it%20should%20be%20written%20would%20help%20me%20also.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20or%20suggestions%20would%20be%20very%20much%20appreciated%20if%20the%20JSON%20is%20not%20an%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EClaire%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1458386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Hello,

I have a document Library where one of my Columns is a Lookup, the list is of Project Names

 

What I would like to do is be able to only show the Project Names that are relevant to the Project Library as currently the list shows everything.

 

Is there a way to only show the Project Name if it's equal or contains the Customer Name?

 

I am not sure if the Format Current View option would work but would like to try it using JSON if possible and I don't have knowledge of JSON so guidance of how it should be written would help me also.

 

Any help or suggestions would be very much appreciated if the JSON is not an option.

 

Thank you

Claire

0 Replies