Copy Contact to Another Cell if Entered

Cary Vaughn

I have five contact columns one table. I have set up the webform where a contact can only be entered into one of those five cells. My question is, if a contact is entered into one of those five Contact cells, how can I copy that information into another cell on the same row?

Cary Vaughn

Figured out the formula:

=IF(ISBLANK([Business Intelligence]@row) = false, [Business Intelligence]@row, IF(ISBLANK([Business Process Architecture]@row) = false, [Business Process Architecture]@row, IF(ISBLANK([Corporate Solutions Group]@row) = false, [Corporate Solutions Group]@row, IF(ISBLANK([Cyber Security]@row) = false, [Cyber Security]@row, IF(ISBLANK([Enterprise Resource Planning]@row) = false, [Enterprise Resource Planning]@row, [Infrastructure & Operations]@row)))))

Andrée Starå

Hi Cary,

You can use a formula to show the contact in the other columns.

Would that work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Cary Vaughn

Is there a formula I can enter in each of the five highlighted cells to duplicate the information entered into the Requester field on that same row? If so, what would that formula look like?

Cary Vaughn

Figured out the formula:

=IF(ISBLANK([Business Intelligence]@row) = false, [Business Intelligence]@row, IF(ISBLANK([Business Process Architecture]@row) = false, [Business Process Architecture]@row, IF(ISBLANK([Corporate Solutions Group]@row) = false, [Corporate Solutions Group]@row, IF(ISBLANK([Cyber Security]@row) = false, [Cyber Security]@row, IF(ISBLANK([Enterprise Resource Planning]@row) = false, [Enterprise Resource Planning]@row, [Infrastructure & Operations]@row)))))

Andrée Starå

Excellent!

Glad you got it working!