-
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…
-
Auto number column type and copy rows workflow
I have two sheets that utilize the auto number column for tracking two different things. sheet two has all of the data sheet one has, including the ID that is autogenerated on sheet one (manual input into sheet two), but it also has additional columns such as the autogenerated sheet two ID. I wanted to create a workflow…
-
Create an automation to set column value on a new row
I'm trying to create my first automation, and although it seems like a dead simple use case, I can't get it to work. I simply want a default value for one of my columns. It's a drop-down column, but it looks like SmartSheet doesn't support setting a default value, and an automation is the recommended approach. So I'd like…
-
Merged: Move or Copy Row Automation should allow for Select Field handling
This discussion has been merged.