Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

DataMesh not finding cell links

Mariya Zabigaylo
Mariya Zabigaylo ✭✭
edited 12/09/19 in Archived 2017 Posts

I am having issues with DataMesh, as it is unable to look up the values between the sheets. I checked some of them manually, and the numbers exist on the target sheet.Β 

I also tried to export into Excel and test this formula. Excel required a re-format of the numbers (text to number format) before it was able to successfully Vlookup the values. I have tried to re-upload the source sheet with different number formatting options and also tried to change them within the Smartsheet (adding decimal spaces, copying into a different column) and none seem to work.Β 

Is there anyone that can help identify what may be causing this issue?Β 

Β 

Comments

This discussion has been closed.