I have 2 sheets Sheet 1: Projects pending approval Sheet 2: All the projects that have been approved I want to build functionality where when I check an approved box in Sheet 1, it will automatically push to Sheet 2. There are a couple issues/ complexities. One of the biggest issue is that the Sheets have different column…
Hello, I have a few mappings set up for city in my sheet where if they match, the address will automatically populate when the new row is added. I have recently also assigned Child rows to my parent rows and the DataMesh is not working on them only the parent rows. How can I fix this?
Hello! I recently received a request to build some form of "batch upload" process, where users upload a spreadsheet filled with contact data and submit it via form. We would then like to move the data from these row-level attachments into columns on another sheet, where contact information from all form attachments is…
Hi Experts, I need help. I have 6 individual sheets that I need to rows to combine inside one Master sheet and update/add rows automatically when the individual sheets gets updates. Is this possible? I know it is possible when we use report builder but I want my Master sheet into Sheet because I am going to make a Metric…
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…
