CONCATENATE("PN: “,TEXT([PN]),” ","Q: “,[Q],” “,“GRC:”,[GRC],” ","LOC: “,[LOCATION],” ","B: “,LEFT([BUYER],6),” ","P: “,LEFT([PLANNER],6),” ","T: “,LEFT([TECH],6),” ","DR: “,[DR],” ","HN: ",[HN])
I’m trying to get the TEXT in the columns such as [PN] to highlight within a virtual column. The regular text "PN: " can remain unchanged.There is no Format Rule that I can think of that works inside of a CONCATENATE expression. The TEXT() function above does not work. [PN] highlights on every other view except where it has been incorporated into a CONCATENATE.
LinkedIn
Twitter
