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
I'm not sure how to tackle this one, all suggestions are welcome (thanks in advance).
A project manager has 50 projects. They want to document that they have reviewed all project activities (tasks, reports, etc) monthly. So they are asking for a basic list of active projects assigned to them and
Was able to connect to smartsheet from excel using the live data connector. The SM table exists as a read only table on a tab in the sheet and I can use index/match to pull values out of the table. This lets me keep one data file in smartsheet and use it across multiple excel sheets
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a
Just wanted to point out that when I did a <Copy to Another Sheet> I discovered that a custom column placed in the first sheet did get copied but it was placed at the end of all pre-defined columns in the second sheet.
A bit confusing since that place was out of view in the