-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Using Sheet Summary To Populate Columns - and Have Same Restrictions
I'm using a sheet summary to add some global sheet data (i.e., it's not associated with rows, it's associated at sheet level.) I've got a sheet summary contact list field where I add the project manager - then it populates the top cell in a column. I then use this cell as an email recipient in a workflow. However, it…
-
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…
-
Collapsable vertical header list to hyperlink to column
In the same way that Dynamic views and WorkApp resources listed on the left can be collapsed or expanded, I would like to see a searchable, sortable, vertical column with scrollbar that lists the headers of all columns in the sheet. Each column header name would hyperlink directly to the column I want. I have 80 columns in…
-
Due in Days and conditional formatting question
I have this formula (below) to calculate my "Due in Days" column, and a conditional formatting rule that states "If due in days is less than 0" then apply a red font. but I'm wondering if I'm able to have it display no number once the task has been completed, or at least remove the red font once the "Status" column…
-
Ability to Customize Displayed Columns on Initial View of Selected Workspace(s)
Currently, after selecting a Workspace from the Browse panel the initial screen displayed has six columns displayed: Select (checkbox; ☑️) Favorite (star; ⭐️) Name Sharing Owner Last Update It would be great to be able to customize these columns with additional data points to aid with navigation and understandability (from…
-
Automation column to column
I would like to automate the behavior of columns. My case is to create a list of our department's contacts as task assignments and in a separate column note the team the person is on, so, for example, Jane Smith is on the Marketing Team, and John Doe is on the Operations Team. Then I would create a USER REPORT for tasks…
-
Allow unlimited deletion of columns like Excel
A major value proposition of Smartsheet is that it can replace Excel. It's then a huge shock to users who have been asked to move to the new Smartsheet platform to find that it allows up to only 5 columns to be deleted at a time. I have seen Smartsheet's response, that the limit is to ensure integrity with the server due…
-
Automation workflow assigning people in a Contact List column - list doesn't match
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…
-
Time Column
I noticed recently that the Time function has been added, it is greatly appreciated. However, with this new function it would be nice to have more robust support around it. I would love to see a new column format dedicated to time (kind of like the Date column). With that, allow a user on a form to select time from a clock…