-
Change "submit" button language
We have been using Smartsheet for a month now and are very happy with the functionality, ease of use and the many options. Unfortunately there is no Dutch version of Smartsheet, this would make it easier to some of our collaborators. We want to use the webform option to gather information. Is there a way to change the text…
-
Jira connector
Is there a way to create a template of the field mappings for the jira connector? We would like to establish a standard mapping for a set of our projects and we are looking for a way to either clone an existing workflow or upload a template.
-
Max Function
I have a formula that finds and returns the maximum of a set of date cells meaning that it finds the latest date. It works fine if all cells are populated with dates but if one cell is blank it error out. This is the formula: =MAX([Due Date]1, [Family Member A Due Date]1, [Family Member B Due Date]1, [Family Member C Due…
-
Smartsheet - Salesforce Connector
Context: In Smartsheet, I have a project intake sheet with many columns of data related to each project. I have set up a workflow in the Smartsheet-Salesforce connector that routinely syncs over relevant data from Smartsheet to Salesforce opportunities and vice-versa. Problem: I am having trouble syncing over the column…
-
Export of Reminders
If I have multiple reminders set up in my Smartsheet, is it possible to get an export of all the set reminders together with the content/message I have written?
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
Is there a formula that will help me to determine if a task has any dependencies (IE: the opposite o
I work on some pretty complex projects and the templates we use have hundreds of tasks that are linked together using the predecessor column. Each project is slightly different and we usually need to delete certain tasks to refine the template into a new project plan. It can be a pretty big pain to delete some of the tasks…
-
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show a…
-
How to update dates to a new future date
Hi I use smartsheet as payroll check system. I normally maintain a group name, pay date, direct credit date. For some groups we pay weekly and for some we pay fortnightly. How do i automate date column with future date once i complete the payroll on certain date. Example Group Name Payroll preparion Date Direct Credit Date…