DataMesh - Renaming Columns
Hello,
My apologies if this has already been asked and I simply could not find the answer.
I am new to using DataMesh and am testing it at the moment. When you set up a Config, you obviously select the Lookup columns in both the Source and Target sheets. Now, while it shouldn't happen, if one of those columns were to be renamed in either the Source or Target sheets, the Config then fails to run with the error message:
"lookup column '[Column name] is missing with (source/target) sheet '[Sheetn Name]'"
My question is, can Smartsheet either stop the "Rename Column" function on columns which have DataMesh dependencies and if so, where do I find that setting?
If not, can it display a warning message where a DataMesh reference of this kind exists?
I hope that makes sense. Thanks in advance for any help that can be offered.
Best Answer
-
Hi @Giles Magee
Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As possible workarounds, you could maybe lock the columns, add column descriptions, or a message elsewhere in the sheet.
Would any of those options 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 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!
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.
Answers
-
Hi @Giles Magee
Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As possible workarounds, you could maybe lock the columns, add column descriptions, or a message elsewhere in the sheet.
Would any of those options 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 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!
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.
-
Good morning, @Andrée Starå.
Thank you for confiming that this is not possible.
Yes, locking the columns with a description would probably work. I will do that and submit the Enhancement request as suggested.
Thanks for taking the time to answer my question.
Have a good weekend!
Giles
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives