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?



Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Ashley Boose

    I hope you're well and safe!

    Yes, with so-called helper columns, it could work.

    You could add another column that would be the one populated by the Legal Address field, and the main one would be the one showing either the helper column or if the checkbox is checked, it will show the Delivery Address.

    Make sense?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Hello again Andrée! Always glad to have your help on here!

    However, I'm a little confused by your response (sorry!). Ok so in the screenshot below, it shows the columns I was talking about that match up with the form fields. If a user (Row 1) puts in their Delivery address and it's not the same as the Legal, then they can enter the Legal address and that's all normal. But if a user (Row 2) enters the Delivery address and chooses "Yes"--that Legal address is same as Delivery address--how do I get the Legal address fields to populate the same data as the Delivery? Is there like an if/then formula or I can use on these columns?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!