-
Imported Hyperlink Text
We have a project management software that generates the above text representing a job location. We import the text to smartsheet though data shuttle so we can distribute dispatch information to our 300 employees. My problem is that the import works as shown above where the URL is incomplete due I'm guessing to the comma…
-
Converting Workflow Automations into Process Maps
Hi all, Long time listener, first time caller here. I was curious to see if this functionality exists in Smartsheet already or if anyone has figured out a best practice on the following... We have several Smartsheets that are deeply intrenched in workflow automation. As I work on process mapping and documentation for the…
-
Error message when accessing automations in copy of sheet
Hi folks, I have a sheet that has 16 workflows that I'm trying to take a copy of. All the workflows are accessible in the original, but when I take a copy and try to select 'Manage Workflows', I get the following (extremely helpful) message. Another user has tried to take a copy and come up against the same issue. It is…
-
How can a general user tell if a Contact listed on a sheet is a licensed user?
As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
-
dropdown list dinamics or smart
buenas tardes! me seria de gran utilidad si alguno ha conseguido actualizar el listado de valores de la dropdown list con valores obtenidos de otra hoja.. desde ya agradezco y me seria muy util Gracias
-
'Save' button for work in progress, for external form-fillers?
We use Smartsheet forms for grant applicants to submit initial information. Without a 'save' button or feature, we've had to advise our applicants to prepare all their answers offline, and then enter all their responses in one session. This can be problematic if the applicant gets pulled away on another task, call, e-mail,…
-
What is the best way to move specific cell/column data when a specified trigger is met?
Customer example is that when information is added to the new order sheet, and marketing lead is assigned, and marketing deadline is populated, there are 5 columns of information that only need copied to the target sheet once the trigger is reached. The source sheet is 50+ columns. We don't want all columns. We've tried…
-
How can a general user tell if a Contact listed on a sheet is a licensed user?
As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
-
Auto-populate emails on a "contact list" column
I have a Form created for internal employees where they can submit request tickets to my department. We all have an account with Smartsheet. One of our columns ("Requestor Name") is in the Form where they type in their names. The "Requestor Name" column is a Contac List column. My issue here is, how can I have Smartsheet…
-
Any idea on how to develop this automation?
I am tracking the health project status between meetings, so I have a "Current health" (Overall Health) column and a "Last meeting health" (Last PRC Health) column, right now I am doing it manually which is very time consuming. Is there a way I can copy and paste a value based on a specific date? or maybe manually…
