Forum Discussion
UrsulaLl
8 years agoQrew Assistant Captain
I'm assuming the "& -Rev &" is part of the text to go inbetween digital front field and revision field.
Using the \ to escape out the quotes works, but it makes it harder to read, so I have replaced that with single quotes. The & needs to be in front and behind the QB field you are using. Hope this works!
If(Contains([Cut Status], "Fabrication Ready"),
"<div style='background-color:#0CF52B;'>(" & [Digital Front] & "-Rev" & [Revision] & ")</div>",
[Cut Status])
Using the \ to escape out the quotes works, but it makes it harder to read, so I have replaced that with single quotes. The & needs to be in front and behind the QB field you are using. Hope this works!
If(Contains([Cut Status], "Fabrication Ready"),
"<div style='background-color:#0CF52B;'>(" & [Digital Front] & "-Rev" & [Revision] & ")</div>",
[Cut Status])