-
Using CountIfs to track a column will multiple options
Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts all instances? Formula below for example =COUNTIFS({Training Project Task List Range…
-
Can Groups be added as a contact in a contact list column?
-
Cannot find new address for a contact from an automation or sheet
We did not want emails to go to external contacts, so "tricked the system" by creating contacts with the same internal email address: eg. Contact 1 : contact1@internalemail1.com Contact 2: contact1@internalemail1.com Recently, smartsheet blocked this approach and does not let us create multiple contacts with the same email…
-
Filling out a FORM + requesting approval from a colleague
Hi there! Right now, we have a PDF application filled out and emailed to managers to sign/approve. I would like to transfer the PDF application to a form. done. I am struggling with the "managers approval" part. I want applicants to type in their managers email, and somehow have that manager "approve" their application. I…
-
Notifications for Contact List Column Option
Just wondering if the notification for contact list within a column setting has been resolved and we can now get notifications when something has been assigned to us?
-
contacts
I have entered my smartsheet contacts manually including their email and name. Afterwards when using my contacts to send out update requests, only the email for the person is displayed for about 1/2 my list, the other 1/2 has both email and name. This display changes at times. I have edited their contacts and added the…
-
Using Match Function with Multiple Contact Column
Hello, I need to lookup a value in a table when a specific contact matches. I tried using match/index, however the column containing the contacts in the lookup table allows multiple contacts which I am unable to determine how to use match with multiple contact listings. The use case is as follows: Send an email alert to…
-
USING FORMS WITH pARENT /CHILD ASSOCIATIONS IN SPREADSHEET
Greetings, Below is a screenshot of a spreadsheet that has parent / child associations. I would like to create a form that will allow team members to input the various meetings & Times, they have during the week. 1-can smartsheet automatically put the response in child rows when a parent row( week Day) has been selected?…
-
Prevent Overwriting of "Handler" Column
Hello, We have a smartsheet for our support team to claim requests submitted. As of now, when a form is submitted- every member of the support team receives an alert. From there, one of them must enter the sheet and elect themselves to handle the request (dropdown field with their names). We've run in to an issue where…
-
Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…