Data Mesh scheduling - new row in the target sheet

I have a configuration with Execution Frequency = Immediate and Data Mapping Format = Create Cell Links. When I add a new row to the target sheet, mapped cells do not get their link in the new row. If I change the schedule to 1 Hour, links are added. 

Q: If all my mapping is Create Cell Links, then I don't need a frequency of immediate since they are links, right? Meaning, data in the target sheet will always reflect what's in the source sheet whether the configuration is running or not.

Q: Is there any way for a new row to get data immediately from the configuration or is hourly the best available? 

Comments

  • Anthony M.
    Anthony M. Employee Admin

    Hello Phillip,

    Thank you for reaching out. I'm happy to help with your Data Mesh questions.

    Q: If all my mapping is Create Cell Links, then I don't need a frequency of immediate since they are links, right? Meaning, data in the target sheet will always reflect what's in the source sheet whether the configuration is running or not.

    A: The frequency in this particular situation would be for adding any new rows to your target sheet. The already created cell links, as you state, will always reflect what's in the source sheet once they have been created.

    Q: Is there any way for a new row to get data immediately from the configuration or is hourly the best available? 

    A: Update immediately is available for configs built off a source sheet. If your config is built off a report, update immediately will not be an available option. If the config happens to miss the update immediately window, for any reason, it will update on the next hourly sync. If you are seeing any issues with update immediately not working as expected, please feel free to reach out to our support team directly. There will be some additional troubleshooting and information we will need to collect.

    Thank you for your time, Phillip. Please don't hesitate to open a ticket with us, for further troubleshooting of your Data Mesh configs. https://help.smartsheet.com/contact

    Kind Regards,

    Anthony

    Smartsheet Support