How to populate cell(s) with content from other cell(s) if value of helper column is yes
I am building a form right now that asks for the user's delivery address and their legal address. Instead of filling out the address twice (if it is the same), can I set it up where if they are the same, the cell(s) for the Delivery address populate the cell(s) for the Legal address?
My idea was to add a field beneath the Delivery address field(s) that asks if their Legal address is the same as their Delivery address and if the answer is "No", then the Legal address fields would show so they could fill them out with the different address. But if the answer is "Yes", the Legal address fields would stay hidden, but after submission, the Legal address would fill with the same address that they entered for Delivery. I'm just not sure how to make that happen. Is it possible?
Help Article Resources
Check out the Formula Handbook template!