-
Merged: Dynamic View - @ Mention Contact Name
This discussion has been merged.
-
SUMIFS with a Multi-select Contact Column
Is there a correct way to add contacts into a formula? I am trying to sum the number of attendees per VP (could be a couple VP's in this multi-select contact column) training request. Do I need to type in the full name? Only part? Add in a special function? Details: Completed Projects - Team X # of Attendees = number of…
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
Contact list in forms
My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of available options - but the same feature is not available on through a form. Is there a…
-
Multiple Contact list with Request Update
I have found that I can not include a Contact list column which is set to Allow multiple contacts in a automated request an update action. If you include the contact list column, none of the specified fields will show up and the open request web page only has the message, no submit or field list. The only work around I…
-
Edited CONTACTS - flowing to other sheets
If I edit a contact in My Contacts (the Name portion, not the email), will that flow to everywhere the contact is used (all sheets)? It appears the answer is no, and it takes manually editing each instance of the contant on all individual sheets. Hoping this is not the case, or there's an easy solution or workaround.…
-
HELP What am I doing wrong in this formula?
=INDEX(COLLECT({Unit/Manager List WI Range 1}, {Unit/Manager List WI Range 7}, [Area of Study Parent]@row, {Unit/Manager List WI Range 8}, [Area of Study - Nursing]@row, {Unit/Manager List WI Range 9}, [Area of Study - Radiography]@row, {Unit/Manager List WI Range 10}, [Area of Study - Rehab Services - PT/OT/ST]@row,…
-
How to convert multiple email separated by commas from Text column to Contact list column?
I have a text column that has multiple emails and each email is separated by commas and i am trying to pull those multiple emails to contact list columns (I have allowed multiple contacts per cell ON) and be able to send alerts. However, when I do that it just stays as text, not contacts. Does anybody have any idea how I…
-
Resource Management Joined() Contact Column unavailable.
I have groups where I need to limit the contacts to I would like to track my resources but my "Assignee All Row": It uses: =IF(ISBLANK(JOIN([Assignee Design Architecture]@row:[Assignee Sign-Seal]@row)), "-", JOIN(COLLECT([Assignee Design Architecture]@row:[Assignee Sign-Seal]@row, [Assignee Design…
-
Please enable us to select multiple contacts when sharing (was avialable a year or so ago)
I just noticed the change when sharing a Sheet with someone, I love this newly added capability - thank you for always having the end users in mind! About a year or so ago, if you wanted to share anything in Smartsheet, you had the ability to bring up your entire contact list or type a keyword, you would then be able to…
