Home > Enterprise >  Join range of yes/no answer header replacements values into single cell in google sheets
Join range of yes/no answer header replacements values into single cell in google sheets

Time:04-12

Replace "yes" or "no" values in enter image description here

Goal 1: Combining Yes, No replacement formulas

  1. 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

  1. 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"

  1. 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:

enter image description here

How can I modify the equation in this enter image description here

  • Related