aarguijo

Comments

Ah I figured it out. It wanted a % at the start of the string as well - so case when DP Response 2 LIKE ‘%DP: Sorry%’ then User Question 2 end Thanks so much for your help!

in Any way to get text value from one column based on text value of another column? Comment by aarguijo March 2023
@MichelleH that did help with the syntax error, but somehow I'm getting no data returned with that formula as a whole. Do you know if I'm missing something that would actually pull through the value of the “User Question 2” column?

in Any way to get text value from one column based on text value of another column? Comment by aarguijo March 2023