Hi - I just started using SmartSheet and am really excited by what it has to offer.
I started to explore DataMesh and have some feedback/queries on it;
Queries - I created a config with ~100 columns - it took me a very long time to do the mapping. Now that it is completed I realized that it links to a specific source sheet - and unless you copy & paste data into that same source sheet (which when dealing with large amounts of data is painful to do), you need to create a new Config linked to the new Source sheet. Given it took me a lot of effort to create the initial Config it would be great to have the ability to update the source to a different sheet, or be able to clone the existing Config and make slight edits without having to recreate everything. My new sheets have exactly the same column layout as the original sheets, but will just have new data in them as they get run daily.
What's the best workaround for this?
Feedback - it's time consuming selecting the source columns you want, then having to reselect them again in the destination section. Please consider improving the UI here to make it easier on us as users. Also when we have long column names the UI cuts them off making it hard to tell if you have accidentally included a duplicate. There is also no easy way to re-order or add/remove a column selection without impacting every other selection you made further down. It would be great to provide more functionality around this in case you want to re-order things after inputting 100 odd columns.