How to replace a blank field with contents from another

SueinSpain

Hi Community I need help,

I have an onboarding form where there are many addresses to be captured.

The registered company address is mandatory

The main address is optional on the form as only needs to be filled in if different from the registered address.

That is great for the form but on the smartsheet I need both filled in so…….

If the main office address is blank I want to copy the registered address field into the main address field.

I cannot put a formula in automation for changing a cell value

if I put the formula in the main office address field is is circular so won't work

I can create a 3rd address field and use the formula to populate it based on the main office being blank but …..there are 5 columns for each address, already 10 columns for the 2 addresses and this would add a further 5……. so feel getting a bit over the top.

Any ideas anyone as this would be VERY gratefully appreciated

Many thanks

Sue

p.s. apologies if this has been aslked before but I couldn't find it

Andrée Starå

https://community.smartsheet.com/discussion/122518/how-to-replace-a-blank-field-with-contents-from-another

Hi,

I hope you're well and safe!

Unfortunately, you must add the so-called helper columns and collect it that way.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

SueinSpain

Thanks Andree, I suspected as much

Andrée Starå

https://community.smartsheet.com/discussion/122518/how-to-replace-a-blank-field-with-contents-from-another

Hi,

I hope you're well and safe!

Unfortunately, you must add the so-called helper columns and collect it that way.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

SueinSpain

Thanks Andree, I suspected as much

Andrée Starå

https://community.smartsheet.com/discussion/comment/437909#Comment_437909

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!