...
Projector project data → Smartsheet sheet (task plan)
Working days and holidays
Role updates (assignments are cleared if a role is missing)
New as of Aug 19, 2023 - On the initial synchronization after linking, but not on subsequent syncs, roles from the linked Smartsheet sheet are created in the Projector project. If a resource is assigned to the role and the resource name matches with the resource display name in Projector, the newly created project role will be assigned to the resource in question.
Task type updates (task types are cleared if a type is missing)
Updated role resource assignments
Task % complete (future enhancement)
Undeleted & repaired tasks in necessary
Smartsheet planning data → Projector project
Task name & duration
Task assign to (role) & allocation %
Task start and end date (duration is calc’d by Projector)
Task type
Open/closed for time
Projector does some work behind the scenes
Makes task plan data available to:
Budgeting
Reporting
BI tool use
… and the rest of Projector
Emails are generated as appropriate
...