Using Datamesh to copy over an existing formula

Options
pe22
pe22 ✭✭✭
edited 06/14/22 in Add Ons and Integrations

I'm trying to run a datamesh over a column that has a formula entered in.

The column is supposed to show "N/A" through the formula until there is data to copy over from the source sheet.

I want the Datamesh to copy over the formula, but instead it shows a red triangle in the details of the datamesh config.


Is there anyway around this?

· Share on FacebookShare on Twitter

Answers

  • Ben Goldblatt
    Ben Goldblatt Employee
    Options

    Hi @pe22,

    I highly recommend contacting the Support Team to see what may be causing the error in your DataMesh configuration, as they will be the best resource for troubleshooting this type of issue. You may also want to look into our Pro Desk services to work with one of our experts in a "Premium Apps" session. They'll be able to review your config, offer tips and best practices, and may also be able to pinpoint the root cause of the issue or provide insight on other possible options to accomplish what you're looking for.

    You may also find some helpful information in the DataMesh Help article.

    I hope this helps!

    Thanks,

    Ben

    · Share on FacebookShare on Twitter
  • pe22
    pe22 ✭✭✭
    Options

    Thanks Ben. Turns out I didn't match the primary key fields...I had just set it as the unique identifier.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video