-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Improve how logic functions work with contact columns
If a contact (e.g. one in my personal contact lists) has a text field name associated with it, it displays as that name. Then, if wanting to search for that contact in a contact column using the associated email address, it is not found. Please develop a function that returns as text the email address of a contact.…
-
Add Email Distribution Lists Functionality to Contact Columns & Workflows
Our team and company use email distribution lists frequently, so it would be incredibly useful to be able to assign an email distribution list to a contact column and workflows so all members on that list would be notified accordingly.
-
Split Contacts Past 20 Into a Separate Column
Hi, I have a form that is filled out to send a notification to a group of staff. The person creating the message fills out the form and pastes the list of email addresses (separated by semicolons) from another source to populate a Contact List column and automation sends a notification and reminders to the staff on that…
-
Dashboard - Embedding links to email addresses
I've seen some past posts on this topic but have not gotten the workaround to work and was hoping that there may be progress on a solution. At the 2020 Engage event, I saw a beautiful dashboard that had images and email links under a title: contacts. I'm trying to create the same on my dashboard. Any help or update? This…
-
My Smartsheet Contacts sometime display as email, and sometimes as name??
Some of my contacts display as their email address and others will show the name. I would like them all to display the name in the sheet. Is this possible?
-
Merged: Sharing contacts in different sheets
This discussion has been merged.
-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
User Management - Custom Job Categories
Allow entry of custom job categories. Add new fields to capture a user's business unit and department. These fields should also be included in all user reports. This functionality would be helpful for businesses that cross charge business units and depts for licenses and usage.
-
Merged: Updating distribution list for Auto delivered reports
This discussion has been merged.
