Mandatory "pick value from list" field in Global Update

Mirelle Almeida

Issue with the Global Update feature, specifically when trying to add a new value to an existing column without altering any existing values.

Here's the situation:

1. Objective: Add the value "Cancelled" to the "Status" column in the Project Plan.
2. Approach: Global Update functionality to ensure this change is reflected across all active projects.
3. Challenge: While configuring the Global Update, I encountered an obstacle when dealing with the mandatory "pick value from list" field. Since I am not intending to modify any existing values, I'm unsure how to proceed without specifying a value to be changed.

How to overcome this situation and successfully perform the Global Update without altering any existing values in the "Status" column? Is there a workaround or alternative approach that can be used to achieve this objective?

Thanks in advance.

AravindGP

Hi Mirelle,

When applying the global update to modify the column, right under the selection of the column name, there are two checkboxes. One to change column property and the other is to change column cell data. Both are checked by default. To ensure only the new dropdown values are pushed and no existing values are updated, all you have to do it uncheck the box which says Change column cell data. This will remove the Pick value from list option altogether and you can apply the update.

AravindGP

Hi Mirelle,

When applying the global update to modify the column, right under the selection of the column name, there are two checkboxes. One to change column property and the other is to change column cell data. Both are checked by default. To ensure only the new dropdown values are pushed and no existing values are updated, all you have to do it uncheck the box which says Change column cell data. This will remove the Pick value from list option altogether and you can apply the update.

Mirelle Almeida

Problem resolved!

Thanks a lot, Aravind!