-
Contact List validation
Hi Everyone, I am managing a pipeline tracking sheet, and there's one intake form and one dynamic view connecting with this sheet. For the column "Branch Contact" and "Sales leader", I set the filed type as "Contact list" and the validation as "No validation". Once I input the username in the intake form, I go to the…
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Lock the background sheet while searching for contacts
Today I accidentally pressed the backspace key while trying to search for a contact (I know, my mistake). I had a cell selected in a sheet when I opened the contact search. The backspace key applied to the cell, deleting information that I need. Fortunately I noticed and recovered the information, but it was out of sight…
-
Backspace Functionality on Contact Object
Personally, I am infallible and have no need to remove a single character that I have ever written. However, I am assuming the rest of your users may misspell a name on occasion, or perhaps misplace a '.' in an email address on occasion. For those unfortunate individuals that fall victim to their own imperfection, the…
-
Detect Duplicate Form Entries
Hi, I have a SS Form to capture my team's attendance on a daily basis, specifically the dates, leave type. I am capturing the employee's name using the Contacts type field in the form. Now, on the form, when I make an entry for a specific name, dates and leave type, is there an option to detect if the same entry was…
-
🇦🇹 Smartsheet User aus Österreich hier?
Servus zusammen 👋 Gibt es hier auch Smartsheet‑User aus Österreich? Es wäre cool zu erfahren, wer in der Nähe ebenfalls mit Smartsheet arbeitet – zum Austausch von Erfahrungen, Best Practices oder einfach zum Vernetzen 😊
-
How to Filter on Blank Cells in a Multi-select Contact List Column
We have a ticketing system that has an assigned column that is a multi-select contact list column type. Before I switched it to multi-select I had a filter that showed the current user and any rows where the assigned column is blank. When I switched to multi-select the blank filter stopped working. I tried a helper column…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…
-
What to do when contacts in a cell are higher than 20?
Hello, my request form allows individuals to select teams that will participate on a project. And for each team, there may be multiple emails associated. My email list can grow quickly from from a few for some small projects to 50 individuals for larger ones. I have a datamesh running that copies the cell containing the…