Populate a column based on a Smartsheet User Profile data

Mary_A ✭✭✭✭✭✭

Is there a way to access the fields in a Smartsheet User Profile.

  • I have an Assigned To column which can contain a single Contact List type.
  • Each single contact in Assigned To is also a Smartsheet User.
  • I have a corresponding Assignee PH# column in the same row.

Is it possible to populate the Assignee PH# by doing a match/lookup that pulls from the user profile Work phone or Mobile. To be clear, this is what I am trying to get to:

Best Answer