Can you automatically populate the Owners list?

Karrie · 05/17/24

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

Dakota Haeffner · 05/17/24

@Karrie,

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", ""))

Karrie · 05/20/24

https://community.smartsheet.com/discussion/comment/436685#Comment_436685

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?

Dakota Haeffner · 05/20/24

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.

Karrie · 05/20/24

https://community.smartsheet.com/discussion/comment/436882#Comment_436882

Thanks! I actually just saw that Smartsheet has an Automated Workflow that will populate a contact field with the actual Smartsheet contacts.

Dakota Haeffner · 05/20/24

@Karrie Awesome! 🤩

Can you automatically populate the Owners list?

Answers

Help Article Resources

Categories