Hi Smartsheet community
We have table with multiple rows. Appreciate guidance on how to auto populate 'Contact' column with email addresses. Thank you very much!
I mean a pre-built reference table that has everyone's names in one column and emails in another that can be used as a lookup table to pull the email based on the name in the working sheet.
Do you have a table built where all of the names are listed in one column and the respective emails listed in another?
Please see image of table. Approximately 2500 - 3000 rows.
Task: 1.table is uploaded. 2.send email alerts to Employee Name if 'Complete Status' column = 'Overdue'
One way is to manually select recipients in 'Contact' column. However, there are 2500 rows and new table uploaded every week (not feasible)
Look forward to your answer. Thank you very much!
We do not have a pre-built table of 'Employee Name', 'Email' columns
Looking for solution that auto populates 'Email' column based on 'Employee Name'. Email column set to 'Contact'
This could be done manually (i.e. select from drop down list). However, it may not be feasible to do this for 2500 rows (or more). Appreciate help and guidance. Thank you.
Since you do not have a pre-built table to reference, you would need to set up an automation that will assign based on the name in the row. The problem with that is you will need to set up an automation for each of the different names.
Otherwise it is going to have to be done manually.
Got it. Thanks
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.