Can you automatically populate the Owners list?
I have two columns: Task Team & Task Owner(s)
Is it possible to automatically populate the Task Owner(s) column based on the value entered in the Task Team column?
Example:
If Task Team = Technical, then Task Owner(s) = Bob
If Task Team = Training, then Task Owner(s) = Kathy and John
Answers
-
Yes totally,
If you are trying to populat a Contact List field I recommend using their email. For example:
=IF([Task Team]@row="Techincal", "bob@techincal.com", IF([Task Team]@row="Training", "kathy@training.com; John@training.com", ""))
-
Thanks! I tried that and it looks like the IF formula doesn't select the Smartsheet Contact.
I am assuming that it likely isn't populate to have a formula select the actual contact and it can only display the email in a form as text. Is that correct?
-
There is probably some syntax-genius who could make it happen, but I've never got it to work with the contact name. I use the email so automations continue to work.
-
Thanks! I actually just saw that Smartsheet has an Automated Workflow that will populate a contact field with the actual Smartsheet contacts.
-
@Karrie Awesome! 🤩
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!