...
Projector project data → Smartsheet sheet (task plan)
Working days and holidays
Role updates
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.
Requirements
the Assigned To text must match the expected string pattern with a role name in parentheses followed by a resource display name outside the parentheses.
the Assigned To resource text exactly matches an active resource’s resource display name. Case insensitive is fine here. [Active resource: has at least one active day starting from today.]
The Assigned To resource text exactly matches an inactive resource’s display name. Role will be created using text in paren, and unassigned. [Inactive resource: has no active day starting from today.]
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
...