Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Datamesh - blanking mapped columns
In Datamesh, when the lookup value in the target sheet is blanked out (delete) or even changed to a value that has no match in the source sheet, all the mapped columns in the target sheet remain with the previous value which makes the data not consistent.
Is there a was to blank out the mapped value if the lookup value is blanked out or if this value has no match in the source sheet ?