If then statement for contacts
I have a Zapier automation that automatically creates a new row with data about a new user. I'd like it to convert the username of the person who created the account into their SmartSheet contact. My issue is that I am not sure how to setup the formula to change a AD username to a SmartSheet contact. I created a separate column called "Created by" where the smartsheet contact will be.
This is what I have so far:
=IF([Created by User], "useradmin", "John Admin", IF([Created by User], "Smith", "John Smith"))
Answers
-
I am also curious about this! I have employee name data pulled into a sheet from Google Forms/Drive with Data Uploader and that process can't fill in the smartsheet contact information in the destination sheet. I need another column that looks at the employee name and returns their smartsheet contact. (I expect to have to create another small sheet with the employee names and coinciding smartsheet contact for the lookup to work.) But if this can be done with a simple IF formula instead, that would be even better!
-
Hi @Abby Warren & @Amy Foeller
Hope you are fine, you can create a separate sheet containing 2 columns 1 for the Created by User and 2 is the contact name then you can use Vlookup or Index with Match formula and convert it to column formula to pull the contacts for you.
Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Created by AD user will be the column that is filled in first.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!