I am currently using DataMesh to copy data from one sheet to another and wondering if anyone has ideas/options on how to get attachments copied over to the new sheet as well. I can't use the copy row feature because there are a number of rows on the original sheet that are unnecessary, and the column names are different on…
I'm rolling out a new process with a client and constantly finding areas where I need to use a work around, only to find that solution won't work in another aspect. For example, I have one sheet with sales data that needs to be updated constantly by the sales team, however, I don't want them to have access to the sheet,…
I am looking to copy an attachment only between 2 sheets. I can't seem to figure out how to do this! I have even looked at Zapier as an option, but not that familiar with it yet, so not sure how to make it work. Any suggestions?
I have 3 sheets that are being used in tandem: Sheet 1 Registration Data Sheet 2 Travel Requests Sheet 3 Cancelled Registrations Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I…
I am trying to build an expense report sheet for external attendees that come to trainings. Is there a way to allow them to submit each expenses separately through a form but then somehow automatically group rows together so that we are only paying each person one time for multiple expenses? These people will only attend…
I'm sure this is simple, but I've searched for a while and haven't found anything similar! I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of pieces that have been requested (through a SS form on another sheet), then another…