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 ent…
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 con…
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) Al…
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 inst…
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 …
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 fir…
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 …
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 …
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 …
Hello! I am trying to count how many rows a contact is entered in a sheet. Do I create a summary field? I am using this formula for my text/number summary fields to count each status (for a report tha…
