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
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.…
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.
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…
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…
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?
This discussion has been merged.
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…
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.
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…