Sign in to join the conversation:
I couldn't find anything about this but I'd like to just double check with the community. Is there a smartsheet equivalent to Merge Queries in excel. Basically joining two tables based on a common field
Try using the Datamesh App.
Thanks for the link! I did a quick read on datamesh but it wasn't clear to me that it would let me merge the data. I'll have to research some more. Our plan doesn't include datamesh at this time but I still want to figure out if it will work.
thanks again!
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
Is there a way to have a master report that is pulling in the data from all of the necessary sheets and then several minor reports off this one where certain rows can be shown in certain sheets? The reason for this is because as projects get created in the workspace the admin then has to go into 5 reports and link the new…
