Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
Arthur,
The only way would be to set up an If function that would populate a field based on criteria.
James
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?
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.
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
