Discussion List
Clear a sheet using Bridge
Hi all, I have developed a Clear Sheet solution using Bridge. Using Bridge allows you to incorporate a sheet clear into a Bridge workflow, rather than trying to align timing between workflows and other sheet clearing methods like automations and Data Shuttle. Once setup, you simply call this Clear Sheet workflow using the…
Why can't I use hourly, daily or weekly on this automation?
I'm trying to make a daily notification for the automation below. But it won't allow me. Can someone provide ideas of what I'm doing wrong?
RM to Smartsheet using Bridge: Smartsheet Add Row (bulk)
Hi, I am reading Time Entries from Smartsheet Resource Management (RM) and writing them to a Smartsheet. In RM, the project is divided up into phases, which results in Time Entries being associated with each of the phases. The number of phases can be different for each project. Since there are hundreds of Time Entries to…
Arrows in a text row with other text.
I have created a sheet to track roadway sign damages and repairs. I have text column where I add the message for each sign. I want to add an arrow in the text string. Currently it shows: "Greenbo Lake / State Resort Park / (left arrow) 15 Miles" The 'slash' / denotes a line break. I want the (left arrow) to be an actual…
Count String Occurrence in a sheet summary
This discussion was created from comments split from: Count String Occurrence in a Cell.
Sharing with a client without Licenses
Helo, I am attempting to share workspaces with a client that does not use Smartsheet normally. Some of the team members do not have licenses or have used their free trial already and cannot access what we need them to. Is there a way they can extend a free trial or access the workspace without having a full smartsheet…
Form submission copy
Are you able to get a PDF copy of a form submission attached in your sheet? I know the person completing the form can be CC'd on the submission. However can an attachment of the form submission be put into the sheet or only populate the data cells in the sheet?
Copy and Paste Column's
Need a way to copy and paste columns from one "standard columns" sheet to new sheets. This would be similar to a template but more flexible.
Find the position of an element in a dropdown list
I have two columns: Column One: It's a multi-select dropdown list with the names of products (the quantity of selected products can be very long) Column Two: It has the quantities of each product in the same order as Column One, separated by commas. Example of one row: Column One (dropdown list with multiple choices):…
How can I "count" with Business/Holidays if there are blank cells?
We are creating an Out of State(OOS) Request to Smartsheet. EEs can submit up to 3 requests at one time to work OOS. Some people only had 1 requests - meaning the other 2 requests are 0. How do I create a formula that calculates the days (Business days and excludes Holidays). the 1st request (green) has 3 dates submitted -…