Can I have a cell populated with specifc text based on another cell's contents?
One of my forms has a field that requires a Yes or No answer and I would need another field to be filled out if the answer is Yes but stay blank if the answer is No.
Example: If Column/Field 1 asks: Is your hair curly? I want Column/Field 2 to show "XXX" if the answer is "Yes", but be blank if the answer is "No".
At first I thought of adding Column 2 as a hidden field to my form with "XXX" as the default, but that won't work because I only need "XXX" to appear if the answer is "Yes". It needs to stay blank if "No". An IF statement in column 2 won't work either because in the event it is "No" (and column 2 is now blank), I need to be able to add text in that cell based on other criteria in my sheet.
Is this possible?