How to replace a blank field with contents from another
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
Sue Rogers
AmerisourceBergen - MWI Animal Health
Business Analyst
Best Answers
-
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!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.
-
Thanks Andree, I suspected as much
Sue Rogers
AmerisourceBergen - MWI Animal Health
Business Analyst
Answers
-
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!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.
-
Thanks Andree, I suspected as much
Sue Rogers
AmerisourceBergen - MWI Animal Health
Business Analyst
-
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!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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!