-
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…
-
Browse for Destination sheet in copy/move row automation
When setting up automation to copy or move a row to a destination sheet: "Select destination sheet" only gives a search bar with no browsing view of my workspaces. I have to remember the name of my sheet and type it in to be able to find it. This is a semi-new change and I very much dislike it! Can we not have BOTH the…
-
Automation - Improved "Change Cell Value" Action based on Cell Type
The "Change Cell Value" action when doing automation leaves a lot to be desired. Currently it seems to only be able to affect Text/Number, Dropdown, and Checkbox columns. There is a separate action to fill out a date for Date cells, but that is also very restrictive in that it only can enter the date of when the automation…
-
Problem with Data Shuttle that is not accepting xlsx files?
Hi All, Anyone experienced problems with Data Shuttle that it is suddenly not accepting the xlsx files from One Drive anymore? From my side when I open the file itself the section "Protect/Unprotect" sheet under Review is greyed out. Could it be that this is due to Microsoft Information Protection that I'm not able anymore…
