Hi,
Is it possible to link to Microsoft 365, or AAD, and pull through contacts for all users automatically?
This way i can type in Jchap and it will come up with my email, or Joe C and it will also populate me for ANY user in the sheet?
Hello @Joechaptaylor,
I'm hoping someone with API or Data Table experience can weigh in to see if there's a better option, but I'm thinking Data Shuttle might be useful here. If you can have your user list auto-exported to a Sharepoint or Google Drive, or if you manage your users within a Smartsheet itself, you can use Data Shuttle to automatically add users (email address or name, not both unfortunately) to a contact list dropdown, so that they can be selected from either the sheet or a form.
ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
