Datamesh- not updating when target lookup value changes

david voight
david voight ✭✭
edited 12/09/19 in Smartsheet Basics

Datamesh is working fine when a new row is inserted OR if the target field is empty.  However, in an instance when the target lookup value changes, it is not recognizing the change

In our example, Column A is the lookup value and column B is the cell we want updated.  When column B is empty, datamesh works fine and populates column B.  However, if we update the value in Column A, it should rerun and place a new value in column B.  It is not doing this even if we run the datamesh manually.

We can get it to work, but deleting the value in column B and then rerunning the mesh, but there is not a chance i can get our clients to do that consistently.  

Any thoughts would be appreciated.  First screen shot is target sheet.  Second screen shot is source sheet.  Third screen shot is datamesh setup

datamesh target.jpg

datamesh source.jpg

Datamesh Setup.jpg

Comments

  • Anthony M.
    Anthony M. Employee

    Hello David,

    I'd like to follow up on this post and close the loop here. We currently have ownership of the ticket you created along with this Community post. We have engaged our escalation resources on the issue and are currently researching the behavior you have mentioned here.

    Thank you for your time and continued patience. Should you have additional questions or concerns regarding this information, please feel free to reach out on your ticket at any time.

    Kind Regards,

    Anthony

    Smartsheet Support

  • Jon_JB
    Jon_JB ✭✭

    Hi Anthony,

    Did this issue get resolved under the ticket? I seem to be experiencing the same issue today?

    Thanks

    Jon