FluentPro Help Center

What do you need help with?

Smartsheet -> Project for the web migration supported entities

All information in this article also applies to the Smartsheet -> Project for the web and Smartsheet -> Planner (premium 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

-+

 

Only attachments added in the row comment.

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

 

Default Mapping:

Assigned To

Compatible field types:

Created By

Modified By

Contact List

+

Assigned to

 

Default Mapping:

Start

Compatible field types:

Datetime

+

Start

 

Default Mapping:

Due Date/Finish

Compatible field types:

Datetime

+

Finish

Finish=Start+Duration. If the duration is not mapped, then both Start and Finish dates are migrated. 

Default Mapping:

Duration

Compatible field types:

Duration

Text/Number

+

Duration

 

Default Mapping:

% Complete/Status/Done

Compatible field types:

Auto-Number

Checkbox

Duration

Dropdown (Single Select)

Text/Number

+

% Complete


 

Compatible field types:

Duration

Text/Number

+

Effort/Effort Remaining

 

Compatible field types:

Dropdown (Single Select)

Text/Number

+ Priority

Attachments

+

Attachments

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

Default Mapping:

Predecessors

Compatible field types:

Predecessors

+

Dependency

 

Default mapping:
Dropdown (Single Select)
Dropdown (Multi Select)
Symbols
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.

 

Supported Task Custom Field types for mapping

Source Task Custom Field Type

Target Task Custom Field type

Note

Datetime

Created By

Modified By

Auto-Number

Contact List

Dropdown (Single Select)

Dropdown (Multi Select)

Text/Number

Text

 

Auto-Number

Checkbox

Dropdown (Single Select)

Text/Number

 

Number

Only number values from fields of Text/Number type will be migrated to any target field of Number type. 

Datetime

Date

 

Checkbox

Dropdown (Single Select)

Yes/No

 

Dropdown (Single Select)

Dropdown (Multi Select)

Text/Number

 

 

Choice

 

Was this article helpful?

Table of contents

    Back To Top