Conditional Contact Information

Arthur McRae

Does anyone know if it's possible to set it up so that when certain drop down selections on the form are checked then it assigns a contact to our "Request Owner" column?

JamesR

Arthur,

The only way would be to set up an If function that would populate a field based on criteria.

 

James

Arthur McRae

I figured as much, but it won't let me use a function in the contact type field. Can you use a seperate column to push a value into the contact column? If so how?

Amy Johnson

You cant have a formula in a contact list column... you could have a separate column where the name is populated then use that as a reference for what you would need to manually type in the contact list column. 

Andrée Starå

Hi everyone,

Formulas in contact columns. It's released now! 

https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting