-
Listing Multiple contacts.
Hi, we used to be able to assign and list multiple contacts to row. Now all of a sudden we are only given the option to choose from a drop down list and you can only choose one contact. Is there a way to go back to this feature?
-
Invoke a template from a new record
Use case: I would like for a user to complete one form, and based on a value they select in the form, it logs that entry into a sheet, and also creates another sheet (a template) with a name taken from a cell in the form.
-
Registered vs. Licensed User
Hello! I would like to track the 'Created by' field on my web forms. In order to do that it requires that the "Accessible by" option the web form be set to 'A Registered Smartsheet user (requires login)' be selected. Can that user be a registered user but not a licensed user? Thank you!
-
Can I automatically update the due date of a recurring task?
I have a set of recurring tasks that have regular due dates. For example, one is due every month on the 8th of the month. I have a column in my smartsheet file that tracks the next due date. I intend to use it to send out reminders for team members who have not submitted their work on time. Is there any way to…
-
Printing from Sights
Hi, I'd be grateful for any advice on printing from Sights. Is there any way to print or pdf onto more than one page, otherwise my Dashboard comes out way too small. Thank you Tim.
-
Autofill - Formulas referencing above cell
Hi, I have one column creating a reference numbers for a hierarchy from three hidden columns similar to those using a format of 1.1.01. My Level 2 and 3 formulas are as follows =IF(COUNT(ANCESTORS()) = 0, <ABOVE CELL> + 1, <ABOVE CELL>) Number increases with each row, except where it is 2 or more layers in, in which case…
-
Text under "Comments" Column is in a strange position. How can I fix it? Thanks
Hi, the text should be under "Comments," not over it too (see highlighted text). How can I fix it? Thanks
-
Event Registration with Form & Summary
I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
-
Multiple calendar dates in single row
I have a production schedule that list the issue in the primary column and then column headings with due dates for several items throughout the production process. I'd like to show all dates in each column individually and not with a start/end date. I lose the detail in the middle. Possible? thanks Donna
-
Linking colums from one sheet to another issue
Good morning, I am trying to set up a master document with linked cells across three different sheets. First being an order form, second being a shipping form and third being an install form. All the information will link back to my system ID of which system is being installed. My question is when I highlight my cells I am…