I created a "change log" table, anytime certain fields change, it will log the old data and the new data, then I have a formula field set up to tell me if that field "Changed" or "No Change"
Field is Rich Text:
If([NEW BM STATUS]=[OLD BM STATUS], "<div style=\"color:white; background-color:green;\"> NO CHANGE</div>", "<div style=\"background-color:pink;\">"& "CHANGED"&"</div>")When we download the report for someone to work from - the rich text formula shows up. I need a way to extrapolate just the "changed" or "no change" so people can have an easier time filtering changes.
this is what the report looks like downloaded to csv:
What can I do to get just the "changed" or "no changed"?
Well when you put it like that, it seems obvious! haha!
Thank you so much!!