Datamesh Error Code 5537

Greg Ness

One of my users has recently begun to receive an error message when executing DataMesh. The message is:

Warnings

1: error code 5537; message: Only sheet admins can override validation

There have been no recent changes to the source or destination sheets or to the DataMesh configuration. The user holds Editor-Can Share privilege and has previously been able to run this DM without issue.

Any suggestions would be appreciated.

Greg

Sean Morgan

Hello @Greg Ness !,

Although I was unable to locate any information regarding this error, I feel that it may be best that you reach out to our Support Team here: https://www.smartsheet.com/contact

Let me know if you have any questions

Regards

Sean

Greg Ness

Thanks, Sean.

Phil Wyatt

Have there been any more feedback on error code 5537?

What have I done?

Genevieve P.

Hi @Phil Wyatt

This error may be occurring if you are trying to update a cell with a value that is not an approved value in the Column Properties of the destination sheet. For example, if you have drop-down where only "A" and "B" are allowed to be selected, but your DataMesh is attempting to insert "C" to that cell, you may get this error.

Please check the sharing permission of the user who set up the DataMesh configuration, as only shared users with Admin access can override Column Properties like this. Does that make sense?

Cheers!

Genevieve

Greg Ness

I think Genevieve's suggestion is on target. We ultimately determined that one of our users had re-titled a column that was part of the DataMesh parameters. This resulted in the Error code. When we addressed the changed column title, the DataMesh performed as intended.