Replace "yes" or "no" values in
Goal 1: Combining Yes, No replacement formulas
- The current formula requires separate yes/no columns but I would like to combine the answers showing the replaced yes answers above the replaced no answers and separate with a line break.
Goal 2: Inserting additional header text at beginning of string conditionally When yes/no text is present
I added text insertion based on header text and a delimiter. If "yes" replacement answer has been provided it inserts text from the left of a delimiter in header (the reverse when "no" replacement was provided). For example, a header string is provided like "Likes |Doesn't like " and then Regex
REGEXEXTRACT(J1,"^(.*)|"
will extract the text to the left of the pipe for "yes" answers, another regex to the right for "no"
- I ran into a problem when I tried to create a "condition" where this would only be present if yes/no replacement was present. I did this by trying to RegExReplace this text when not followed by additional text using regex which should have worked, but did not, as shown here: