-
Error Message: "Rows cannot be added to the destination sheet..." for my Copy Row Automation?
Hello All, How can we fix this error? The only change that was made was to the destination sheet and it was to change the owner from one person to another. Would that have anything to do with it? Here is the error in my workflow: Thanks! Ryan Holguin
-
Copyrow Automation Not Working When It Said It Did
Hello All, Can you all help me understand why my CopyRow Automation didn't work even though the Activity Log said it ran? My thought is because changes were made to the ran within a minute after saving it initially preventing it from running even though the system said it did. I can send a snippet of the workflow if you…
-
Change Status Based on Previous Row
I am trying to create a column formula that will change the status of a row to "Ready for Work" when status in the row above it changes to "Complete" I tried to follow the information that was provided this thread, but I keep getting #UNPARSEABLE: I already have an auto-number column (Job # - font is just in white based on…
-
How to Quickly Count Applications in Use on Smartsheet?
Hello! Could someone help me with a question? Does anyone know how I can quickly get a count of the number of applications in use on Smartsheet? Or do I need to access each sheet one by one and check the logs?
-
Merged: Automatic communications without Smartsheet link
This discussion has been merged.
-
Moving Attachments Across Sheets
I have a situation where I need to be able to move attachments across sheets as part of our workflow. I've looked into using Automation and Data Mesh and don't see how I can do this without Automation→ move row functionality. I don't want to move the whole row, just the attachments. I'm already using Data Mesh to connect…
-
Can I automate what lane a card in the dashboard is in based on filling out another linked sheet?
Can I update a dashboard to change status based on another linked sheet? E.g. once tasks 1, 2, and 3 are done I would like the card to automatically move to the next lane/status.
-
Can an automation reference a column from a cell value?
I'm trying to track which users are granted access to various systems. What I would like to do is to have one grid which lists all the System IDs (and various properties as columns) with one system per row, and a unique System ID for each system. Then I would like a grid that lists each user as a row, and the column…
-
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…
-
Dynamic Drop-Down
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
