Automation: Request an update but my contacts are not in a contact column

Jed Rusyniak
Jed Rusyniak ✭✭✭✭
edited 12/09/19 in Formulas and Functions

How can I work around this issue.  My sheet is populating the "Contacts" via formula.  I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" since it appears that Smartsheet doesn't allow this functionality.  Anyone have any ideas how I can work around this?  I'm wanting the sheet to automatically ping "carrier contacts" based on a few conditions but my carrier contacts are not in a "Contact' Column. 

Screen Shot 2019-07-27 at 3.12.27 PM.png

Screen Shot 2019-07-27 at 3.14.31 PM.png

Screen Shot 2019-07-27 at 3.15.43 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!