Mandatory "pick value from list" field in Global Update
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:
- Objective: Add the value "Cancelled" to the "Status" column in the Project Plan.
- Approach: Global Update functionality to ensure this change is reflected across all active projects.
- 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 ✭✭✭✭
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 ✭✭✭✭
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
-
Problem resolved!
Thanks a lot, Aravind!
Help Article Resources
Categories
=IF(OR([Added to CRM]@row = \"No\", [Added to CRM]@row = \"//www.santa-greenland.com/community/discussion/comment/\"), \"Open\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":108402,"type":"question","name":"IF CONTAINS Help!","excerpt":"Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However I need multiple options in each column, so I need the formula to then look for another activity and return a different value based on that.…","snippet":"Good morning, I want to return specific values in a cell based on a drop-down list (single values per column), for example, if Activity = Marketing, then return value 45. However…","categoryID":322,"dateInserted":"2023-08-02T09:54:15+00:00","dateUpdated":null,"dateLastComment":"2023-08-02T12:54:03+00:00","insertUserID":148086,"insertUser":{"userID":148086,"name":"Lisa B 2022","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20B%202022","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbls3ea1kMuE-s37Yj-hmWMgVFXC1jOGRq6oYZd=s96-c","dateLastActive":"2023-08-02T14:41:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":148086,"lastUser":{"userID":148086,"name":"Lisa B 2022","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20B%202022","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbls3ea1kMuE-s37Yj-hmWMgVFXC1jOGRq6oYZd=s96-c","dateLastActive":"2023-08-02T14:41:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3381952098,"url":"https:\/\/community.smartsheet.com\/discussion\/108402\/if-contains-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108402\/if-contains-help","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108402,"commentID":388450,"name":"Re: IF CONTAINS Help!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388450#Comment_388450","dateInserted":"2023-08-02T12:54:03+00:00","insertUserID":148086,"insertUser":{"userID":148086,"name":"Lisa B 2022","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20B%202022","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbls3ea1kMuE-s37Yj-hmWMgVFXC1jOGRq6oYZd=s96-c","dateLastActive":"2023-08-02T14:41:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-02T12:53:23+00:00","dateAnswered":"2023-08-02T10:53:12+00:00","acceptedAnswers":[{"commentID":388395,"body":"
![\"MicrosoftTeams-image](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/QY1ACUAC53AX\/microsoftteams-image-2869-29.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
