-
Bridge examples including Javascript
Hi fellow Smartsheeters! In preparation for my session at Engage 2024, The future of workflows, I'm posting a variety of live Bridge examples to this thread. Each "block" will have a use case description, workflow layout, and (if needed) the javascript code I used. Enjoy!
-
Control Center - Global Update to add a column forumula
I have an Overdue column (column type is flag) in a project plan/task list. I have a formula that calculates when to set the flag indicating that the task is overdue. With the newly added Column Formula feature, I would like to set the existing formula for the column instead of in each cell. The reason is I have discovered…
-
Dynamic View Filter Not Pulling Parent Rows
I have a sheet with a filter where "include parent rows" is selected. When the sheet itself is filtered using that filter, it DOES display ALL parent rows. (Dark purple, light purple, yellow) I created a Dynamic View from that sheet, and I selected "Restrict view by sheet filter" when setting up my Dynamic View, using the…
-
Sync Outlook calendar events into Smartsheet
I am looking for an integration tool that allows outlook calendar items to sync to smartsheet and populate content. Such as an out of office calendar populating the task list with content so that individuals can easily see who is available to be assigned to the task. Another example might be integration of a client's…
-
Auto provisioning of projects in Control Center
I have a Control Center program with 4 different blueprints. I would like to do auto provisioning where I can designate the blueprint to be used at the Intake Sheet level (via intake form). I don't see a way to do this in Control Center and suspect it may not be possible. Has anyone else tried this or can someone confirm…
-
Connecting Smartsheet tasks to Microsoft Planner
I'm looking for help in the best way to connect a PMO Portfolio of Projects in Smartsheets to Microsoft Planner. I want to be able to enable all 'Assigned' rows in each and every project plan to automate into 1 Microsoft Planner carrying over the Project Name, Task Description and Due date. I also want to do the reverse.…
-
BRIDGE - (URL's & IMAGES)
I've created 2 Bridge workflows. Add the URL of an attachment to a row cell. This works perfectly, but the URL is only active for 2 minutes then it becomes inactive. ? Is there a way to make URL's permanent when using Bridge ? Insert an attached image to a row cell I have not been able to get this to work as I intend. ? Is…
-
Copy Row Automation to not include Attachments
Hi Is there a way to copy rows via Automations to EXCLUDE attachments? I know this is possible when manually copying to another sheet. Can you do this with Bridge or via the API? To exclude attachements when copying rows. Thanks you in advance. Regards, Pierre
-
Back to View - View not Displayed
I am setting up a Dynamic View to allow requestors monitor HR actions without making changes to the sheet. I am testing the View to ensure it works and am not able to see any lines that should be available to me to see. I have logged out and back into Smartsheet and I have restarted my computer. I only have the one…
-
How much does Data Shuttle cost?
Hi We're evaluating Smartsheet initially to create a simple CRM but it looks like there could be many other use cases for us. But all would involve data that is generated/updated by other systems - integration via CSV files is fine. So we would need Data Shuttle.I am finding it impossible to get price information for this…
