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.

How to auto-refresh the datamesh vlookups?

heli.kothari ✭✭
edited 12/09/19 in Archived 2017 Posts

Hi EVeryone-


I have a sheet which contains the lookup values to my master sheet, and I have created a few datamesh lookup rules which works well, but if a new row gets added to my master sheet, I need to go to datamesh website and refresh the rules my self. Is there anyway I can automate this so everytime I dont have to go to datamesh?


  • Peter Smith

    Hi, Heli

    How you can do lookup across different sheet? it is hot topic.  I know there is 3rd party app,  Asuzana.  However too expensive. If you have any way to do this task, please let me know 

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭


    I don't know enough of the detail of this but I have a suggestion if you are not already using this....?

    On each sheet that will recieve new Rows added constantly, identify the KPI stats you wish to analyse and use formulae to build a Dashboard at the top of that sheet, showing the addition of all activity below. 

    If you wish to analyse data across multiple sheets then use Cell Linking to take your Data up to a Portfolio sheet. All that will happen automagically in Real time. 

    From there you could use Datamesh to distribute or Sights/Power BI to further analyse and share your data. 

    Hope that Helps? 





  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    In the DataMesh app, there is a way (or was when last I used it), a way to have it periodically run the Mesh (or whatever they call it). It was not intuitive and I believe I could find it again.

    Sad there is no documentation for it (or wasn't when last I used it).

    I was less than impressed with it and we have replaced it on at least once site using AppSheet. 


This discussion has been closed.