-
Dynamic Contact lists - User groups to populate dropdown and/or forms to reference user library
For all the amazing things I can do in Smartsheet, this is a MASSIVE pain point. I need to use contact columns to make my workflows function. We have centralized admin teams that maintain and update user groups… Can I PLEASE reference those user groups in the contact drop down for a dynamic list of active users on a team…
-
2 tracker sheets, merged into one resource sheet?
Hello, I have two sheets, one is a fabrication tracker that tracks different jobs in our machine shop, and we have a design tracker that tracks current designs being worked on. I would like to combine both trackers into one resource tracking sheet that shows [Name] [Job #/ Design #"] [Role] [% Occupied]. Image below is…
-
Workflow invalid issue
Hi all, I have a new (and recurring) issue with certain workflows suddenly becoming invalid. For the most part they are not complicated (see example - simple date record when a status changes), and before this year they seemed to work fine. When I re-enable this one, for instance, it will work for a couple of weeks before…
-
Send individual tasks to assignees.
I am able to make a report with a list of tasks that are filtered as I need. I have an upcoming tasks report, and I have an ending and overdue tasks report. I can send this report out daily or weekly. But this isn't really want I want. I want my guys to get an email tat only consists of tasks that they have not already…
-
Merging Columns together from different sheets.
I have two separate sheets, both tracking job #'s. They are different job numbers and I want to bring those numbers over into another sheet with the column title DRR/Job # (the two different job #'s in one column). Essentially we are tracking the amount of different jobs per persons name so I guess also, how can I…
-
FORMULA WHEN THERE ARE MULTIPLE LINES IN A CELL
I have a sheet that has some rows that have multiple lines. I want to use the qty from each line for a summary formula. I have a formula that works when there are only one line in a row, but I get an error when there are multiple lines. Anyone know of a way to do this?
-
INTUIFACE API Intergration
Add compatibility for INTUIFACE user interface software to communicate with smartsheet via API on all platforms, inparticular IOS. Allow requests from origins, Player running on iOS, with the origin capacitor://localhost (capacitor://localhot) If you were using Intuiface on the web, the origin would be further assistance…
-
Hyperlink to external site in automation message
Hi there - I'm sorry if this has already been asked - I'm having a hard time finding the answer. My goal is to include a link to an external site in my automation messages. For example, folks will come to our business and fill out an online form (through smartsheet). I then have the automations set to go to the email they…
-
Deactivate all automation on a sheet
It would be great to be able to "select all" when deactivating workflows in a sheet. I create templates and archive sheets and if I forget to uncheck the box then I have to go and manually deactivate each workflow.
-
Copying action while building Automation
Smartsheet should have option to copy a specific action and reuse it within the Automation. This will save a lot ot time of building Automation where repeative action needs to be places under different condition. Similar faicility is available in Microsoft Power Automate where user can copy some aciton and reuse the same…