Mandatory "pick value from list" field in Global Update

Options
Mirelle Almeida
edited 06/15/23 in Formulas and Functions

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.

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓
    Options

    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.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓
    Options

    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.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

  • Mirelle Almeida
    Options

    Problem resolved!

    Thanks a lot, Aravind!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!