Home Forums Discussion Corresponding Task Level Custom Field to Project level Custom Field

This topic contains 3 replies, has 2 voices, and was last updated by Larry Christofaro Larry Christofaro 2 months, 3 weeks ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #410591 Reply

    Dear MPUG members,

    Is there any way to automatically update an ECF (Enterprise Custom Field) in Task level once a related ECF in Project Level is changed?
    To detail the scenario: there is a “Sponsor Name” field for project and we created a field in task level with the same name, now I’m looking for an automated way that updates the task level “Sponsor Name” field if we change correspondent field in project level.
    We are using Microsoft Project Online.
    I assume if we used on-premise solution we could update those fields on the database by using some SQL commands; but in cloud solution this is not an option.
    Any idea to facilitate this requirement would be greatly appreciated.

    Regards,
    Naser

    #410593 Reply
    Larry Christofaro
    Larry Christofaro
    Participant
    • Community Leader
    • Expert
    • Forum Pro

    Naser,
    The specific answer to your question is no, but the question back is why? You can include the project level Project Sponsor field with your tasks in a report. You can create a Power Pivot model in Excel or use Power BI, or other options…but you can include it by linking the Project ID. Anyway, good luck with your need.

    #410594 Reply

    Thank you Larry for prompt response.
    You are very right, it doesn’t make scenes to duplicate those details.
    But we use a tool for one of the reports which that tool don’t have access to Project Level fields, so we replicated them in task level and now should maintain them for line 0 task (Project Summary) and you can imagine how difficult is to do this for over 200 projects.

    Thanks again,
    Naser

    #410595 Reply
    Larry Christofaro
    Larry Christofaro
    Participant
    • Community Leader
    • Expert
    • Forum Pro

    Yes, I certainly can… Good luck

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Corresponding Task Level Custom Field to Project level Custom Field
Your information:




− 6 = 1