-
Forms & Contacts - 2 Questions
I have a couple of questions: 1). When a form is completed, you can get a copy sent to yourself. Is there a way it can be sent to multiple people? Our use case is: A file review form is completed and the completed form is sent to the lawyer so, they can file it in the matter folder however, this isn't being done so ideally…
-
Reference Number of Contacts In Cell
Greetings Is there a way to reference the number of contacts in a given cell within a formula? For instance, I have a column titled "hours per person", and a column which is a contact list where I enter contacts. I would like to construct a formula for the "total hours worked" which would be the hours per person multiplied…
-
Reference a contact in IF formula
I'm trying to return a value of "TRUE" in a tick box column if a contact referenced in the same row is a specific person. It's a multiple contacts column too but I've done dummy runs with only one contact and it still won't work. I've tried the following and they don't work, what am I doing wrong? 😞 =IF(CONTAINS("Joe…
-
Need help with formula to automatically fill in Contact List from another column
Hello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) All Staff (Contact List selector (assigned to)) Sheet 2 (reference Sheet) Technician Name - Contains full name Email Address -…
-
@ functionality not showing contact
one of my users has issues when trying to use the @ functionality that sometimes certain users do not show up for her to tag. Other times on the same sheet the person shows up. When I check on my instance the person is always there. Any advice?
-
Prevent cells from changing once value is entered?
I have a multi-contact column that I'm using to fill in other cells. The problem is, if new names are added or removed it reorders the contact list. So when extracting the name to another column, the name of the person can change which column they are extracted into. Is there a workaround for this? For example if I remove…
-
Vlookup Contact List... Recognition after Save
I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter…
-
Alert Someone Automation - Reference Contact In Summary Field
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the body of the sheet.
-
Control for Character Entry on Form
Hi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese characters then have to translate later. Would prefer to restrict on the form itself.…
-
Automatically Select Contact With Column Formula
Hi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from many sheets, a filter that only allows a row assigned to a contact to be shown can be…
