-
Unable to Run Copy/Move Automation
I have several sheets in which I utilize automations to move/copy rows from one sheet to another as the rows move through our workflows. So of course, each subsequent sheet has duplicate column names. I had to make a change that ended up completely breaking all of these move/copy automations. The change that broke…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
-
Automation Copy Rows - Select a Destination Sheet
Hello, I'm running into an issue I've found through past forums. I'm attempting to copy rows from one sheet to another. I am the owner on both sheets. What could be the cause of this? Both sheets are in the same folder… Thank you
-
How to Import MS Project File into Smartsheets, but with the Time stamps from MS Project?
When I try to import MS Project File into Smartsheets, it automatically treats the import as a project and hence the result only appears with the Start Date and Finish Date, and I lose the time stamps in from my MS Project File. I also tried taking an export of excel file first from mpp., but as I export to Excel, I lost…
-
Copying rows, but without automatically adding every single column into the 2nd sheet
I didn't see a discussion about this with a quick search, so here goes: When I copy a row from one sheet to another, the 2nd sheet automatically gets updated to include every single column in the original sheet. This is a real hassle when I have 220 columns in the original sheet, but really only want 40 or so of them in…
-
Any Issues with Automations Being Slow or Not Being Triggered?
For the past three years, we've been using Smartsheet boards, with one board dedicated to managing our production workflow. Once a job is completed, we remove it from the board to make space for other active tasks. This main board also triggers an automation that copies metrics from the primary sheet to a tracking sheet.…
-
Merged: Email a snapshot of a Dashboard daily.
This discussion has been merged.
-
Make Hiding & Unhiding columns an Automation function
Perhaps my "search foo" is a bit rusty, but I could not find an existing suggestion for this specific issue, only several tangentially related suggestions. I believe this is pretty self-explanatory. I have sheets with several checkbox columns that are typically hidden, but often need to be unhidden to perform some action.…
-
Is there a way to automate sorting rows by date?
We have several sheets that require users to update the Next Review Date a year out. Then we have to manually sort so that the tasks are in ascending order. Is there a way to automate this currently? Or some sort of work around that I can use?
-
Automation not displaying sheet I'd like to move rows to
I've had this issue before and still continue to have this issue where a sheet that I create (for archive purposes) is not displaying in the automations for me to move rows to. I created this sheet last Friday and it's Monday now, and the sheet is not displaying. Does anyone know why this is? This isn't the first time this…