FluentPro Help Center

What do you need help with?

Smartsheet -> MS Planner migration supported entities

All information in this article also applies to the Smarthseet -> MS Planner and Smartsheet -> Planner (basic plans) migration scenarios. 

Source System Entities

Supported

Target System Entities

Notes

Workspaces

+

Microsoft 365 group

Microsoft 365 groups are created with the source Workspace names if the corresponding Group Creation Mode is selected in the Migration Settings

Workspace Shares/Collaborators, Owner

+

Microsoft 365 group members

Source Workspace members (users and groups workspace is shared to) are added as members to target Microsoft 365 groups. 

Workspace owner is added as group owner.

The corresponding users should already exist in the target tenant and be mapped

Workspace-level Attachments

-

 

 

Folders

-

 

 

Users

-

Users

Users themselves are not migrated but mapped with the target users. Necessary users should already exist in the target tenant

Groups

+

Users

Users from groups workspace/sheet is shared to are added as members to target Microsoft 365 groups. 

Dashboards

 

 

Resource Views

 

 

Templates

 

 

Reports

 

 

Sheets

+

Project for Web projects and Microsoft 365 groups

New Project for the Web is created, and corresponding Microsoft 365 groups is created as Public ones. Microsoft 365 groups are created with the source Project names if the corresponding Group Creation Mode is selected in the Migration Settings.

Sheet Shares/Collaborators, Owner

+

 

Source Sheet members (users and groups sheet is shared to) are added as members to target Microsoft 365 groups. 

Sheet owner is added as group owner.

The corresponding users should already exist in the target tenant and be mapped

Sheet-level Attachments

-

 

 

Columns

+

 

See the list of the supported column types below

Rows/Tasks

+

 

 

Row Attachments

+

 

 

Row Discussions/Comments

+

 

The comments are merged: 10 source comments will be merged into one target. 

Proofs 

 


Subtasks/Row Hierarchy

-

 

 

Dependencies

-

 

 

Cells and Cell Values

+

 

 

Baselines

-

 

 

 

Supported Source and Target Item Fields

Source Task Fields and Field types

Supported

Target Task Fields

Notes

Default Mapping:

Sheet Primary Column and Title 

Compatible field types:

Datetime

Created By

Modified By

Auto-Number

Contact List

Dropdown (Single Select)

Dropdown (Multi Select)

Text/Number

+

Task Name

 

Default Mapping:

Description/Comments

Compatible field types:

Datetime

Created By

Modified By

Auto-Number

Contact List

Dropdown (Single Select)

Dropdown (Multi Select)

Text/Number

+

Notes

The comments are merged: 10 source comments will be merged into one target. 

Default Mapping:

Assigned To

Compatible field types:

Created By

Modified By

Contact List

+

Assignments

 

Default Mapping:

Start, Start date, Request date, Submit date, Report date, Vacation Start Date, Date requested, First Worked On 

Compatible field types:

Datetime

+

Start Date

 

Default Mapping:

Completed Date, Date Completed, Due Date, Date, Publish date, Deadline, Date of event, End date, Finish, Due Date

Compatible field types:

Datetime

+

Due Date


Default Mapping:

% Complete, Status, Progress, Overall status, % Done, Perecent Complete, Status, Done

Compatible field types:

Auto-Number

Checkbox

Dropdown (Single Select)

Text/Number

+

Progress (Percent Complete)

 

Default Mapping:

Priority

 

Compatible field types:

Dropdown (Single Select)

Text/Number

Auto-Number

Checkbox

+

Priority


Attachments

+

Attachments

Only row attachments: row attachments will be migrated to the target corresponding task.

Compatible field types:

Dropdown (Single Select)
 Dropdown (Multi Select)
 Symbols

+

Labels

Source fields values to Labels can be migrated if the Custom Fields and Attachments token is provided for the Project for the Web connection.

Default Mapping:

Conversations

+

Comments

Only row conversations.
The comments are merged: 10 source comments will be merged into one target. 

 

Was this article helpful?

Table of contents

    Back To Top