Assign value to another cell


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,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!