DataMesh - Renaming Columns

Giles Magee

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.

Andrée Starå

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!

Andrée Starå

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!

Giles Magee

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

Andrée Starå

@Giles Magee

Excellent!

You're more than welcome!