-
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…
-
Please enable us to select multiple contacts when sharing (was avialable a year or so ago)
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 select multiple contacts to share with the same customize message. Please bring that back. It is a much-missed function. Thank you!
-
Text in 'Contact List' variable
Hi all, I would like to bring forward a new idea. I have an 'assigned to' column with a 'contact list' variable. In the settings, I allow to also just enter text of names (for example for people not having a SS account) - as in the settings I did not select 'Restrict to list values only' (see screenshot below). It is all…
-
Text in 'Contact List' variable
Hi all, I would like to ask a stupid question. I have an 'assigned to' column with a 'contact list' variable. In the settings, I allow to also just enter text of names (for example for people not having a SS account) - as in the settings I did not select 'Restrict to list values only' (see screenshot below). It is all…
-
Getting the email address for a contact
Hi, I have a contact column and I need the email address from the contact. Is there a way to derive the email address from a Contact column into another column as an email address?
-
What licensing is required for collaborators, commenters etc please?
Hi, I have searched but can't find a definitive answer. If I create a project plan in Smartsheet and want people to comment, update or collaborate in general, which of those need a paid license please? To clarify, in this scenario the creator of the plan would have a business license. Many thanks.
-
Alert Someone Automation
Hi all, I am attempting to set up an automated workflow for account collections. A single sheet will include cash collections for multiple clients. I have RYG triggers set up to run alerts on the 5th day once and then recurring daily on the 10th, no problem. My issue lies with the contacts. I have separate contacts listed…