-
Auto Fill a Contact Column
I need to have a contract cell automatically fill with the contact cell above it. The column type is contact list and I want the user to be able to select the contact in the first row and have the rest of the rows automatically fill with that contact.
-
Formulas in Contact Columns
Please please please make it possible to use formulas in contact columns! :)
-
Is there a way to easily share Sheet with all "Assigned To" contacts?
Is there a way to easily add all the contacts from a Sheet's "Assigned To" column into the "Invite Collaborators" field when trying to share the Sheet?
-
Create Contacts Automatically
If I have First column full of names and Second column with respective email ID, I want a way to create a contact automatically in third column. Please see the image below. I want to get the contact created automatically based on data from other two columns. I will explain my use case. Please suggest if there is any better…
-
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
-
Edit Contact - Include Phone Number
Hi Community - I'm looking for a way to associate phone numbers with contacts (in addition to their email address). I would like the ability to hover over a contact's name (in an Assigned To column, for example) and see not only their email address, but also their phone number and perhaps additional information such as…
-
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
-
Weekly Automated Staus Emails to Clients
I'm running a landscape installation company in Smartsheet and I'd like to set up a way to send an automated weekly email to the client's email address stored in a contact column with their jobs that are coming up in the next few days. In my sheet, each row represents a job and I have a start date. I see that I can filter…
-
Using Contact List Column Type in Task List Forms
I made a recurring task list based on the template Smartsheet provides. I have tasks assigned to different contacts in a contact list column, and users enter new tasks through a webform. My issue comes when they enter the "Assigned To" name. Even if they type their name EXACTLY how it is on their account and in the current…
-
Read receipt
Good Morning, Is there a way that if I @someone on my smartsheet and it sends them an email that I can be notified when they click the link and look at the smartsheet?
