- Return a Contact from another Sheet based on value
Hello, I have a source sheet (Sheet A) that maintains a list of projects and assignments. I need a second request sheet (Sheet B) to intake requests. On this sheet, the project name will be included. I would like to use a formula to output the name of the assigned staff member for that project (found in sheet A). (*the…
- Multiple contacts selected to a task - calculating costs of effort
Hi, I have hourly rates for employees that are in the contact list. I calculate the costs of tasks assigned to a single contract with with no problem. However where multiple contact are assigned I cannot find a way to split out the contacts selected to then allow me to calculate their costs at individual rates Fred £10 per…
- Additional data/fields for contact
Hello Team , The Contact feature as of now include only contact name and email I would like to suggest to add more fields for a contact . Example : Mobile and Phone , Address and photo specially for non smart sheet members This is will help us to reduce adding many columns that not needed just to add above data. might have…
- Contact List - Extract First / Last Name?
Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there a way to only get the first name?
- Card View and Contact List
Hi, Would it be possible to have Card View work with a Single Contact List without having to pre-define emails that would be assigned to the Column? Currently, unless an assignment is done and set up as a default contact on the column, it will not appear in Card View. Thank you
- IF Formulas and multiple contact list
I am creating a workflow for a group of people and I want to assign roles when a specific cell (i.e. Doc Type) has been selected. However, I use the formula: =IF([Doc Type]@row = "ABC", "Sahand", IF([Doc Type]@row = "ABCD", "Jamie")) However when the results only show my name within a text format instead of a contact. Is…
- Configuring a Metrics Widget - can it be done?
Full disclosure - I have been using the PMO template and modifying it for our needs. It was a great starter, but needed some additional tweaks to suit our purposes. I added a sheet that dynamically collects all the unique names to make it easier to dynamically display them on my dashboard: (a big thank you to @Cleversheet…
- Legacy Resource Management & Multiple Contacts
Hi Community, I am working on a project that has several sheets. The sheets have multiple tech's assigned to each project on the same row. Does Legacy Resource Management not work if the contact column is shared? I'm missing quite a number of my resources whom are all part of my account. Thank You!
- 联系邮件addr列显示esses, but I need to extract the First & Last Names
Okay so the title is a bit confusing, but here's the issue: I have a sheet where I need to collect emails so I can send update requests, alerts, all that jazz. Through a form, people input their email addresses into Column 1. Then, using the function =[Column1]@row] in a Contact Column named Column 2, all of the data in…
- Accurately Count if Multiple Contacts are in a Cell
Hi, I am really struggling trying to map out certain data points, when it involves our sales reps, because we can have multiple contacts in a single cell. In this particular instance, I want to find out how many quotes a sales rep has issued this year. Problem is, multiple sales reps can quote the same job, so another…
