Assign value to another cell

Stefanie S.

Hello,

I have a form that includes the following fields:

Company Contact Name (text field)

Supervisor Name (text field)

Check if supervisor is the same as the company contact (checkbox)

How do I copy/paste the Company Contact Name automatically to the Supervisor Name if the checkbox is filled? I've tried using a formula

=IF([Supervisor is Contact]@row = true, [Company Contact Name]@row, "")

in the Supervisor Name column, but then that makes the Supervisor Name field disappear from the form.

Thank you,

Stefanie

Andrée Starå

Hi @Stefanie S.

I hope you're well and safe!

If you don't have too many options, you could do it with a Workflow combined with the Assign people Action.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Stefanie S.

Thank you for your reply @Andrée Starå. I just tried that and when you get the option to assign people, it only lets you enter in an email address, not reference another field.