Anyone has a problem Datamesh error code 1302;You cannot edit cells with Column Formula for column(0

Napassorn

Dear Support,

I created a Datamesh with lookup value from a Formula column (source column), once run the config, then show error "code: 1302; message: You cannot edit cells with Column Formula for column {0}"

Is Datamesh unable lookup from any formula column?

Anyone have the solution yet?

Best regards,

Napassorn C.

Datamesh error 1302 02.png

Uploaded May 21, 2024191.82 KB

Napassorn

Hello Everyone,

I found out that Datamesh is unable to update on any target columns with formula. So, I ignored all those formula target columns and run the Datamesh config again, It is working.

Thank you very much.

Napassorn

Napassorn

Hello Everyone,

I found out that Datamesh is unable to update on any target columns with formula. So, I ignored all those formula target columns and run the Datamesh config again, It is working.

Thank you very much.

Napassorn

Andrea Cary

@Napassorn,

How do you "ignore" any target columns with a formula to make the configuration work?

Thank you,

Andrea

PSExcellence

Andrea Cary

Dec 4, 2024

@Napassorn,

How do you "ignore" any target columns with a formula to make the configuration work?

Thank you,

Andrea

I'm pretty sure what they mean by "ignore" is they aren't including that column in the Datamesh mapping.