联系人列表列选项的通知

My bad. I found the error.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 20:28:34","updateUser":{"userID":152316,"name":"Christian G.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20G.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/8ZFKAYNV3BAL\/n8XVTBY1DO7FK.png","dateLastActive":"2022-11-07T20:28:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}]},{"discussionID":97452,"type":"question","name":"Is there a way to auto populate a cell whenever I enter data in a row?","excerpt":"Is there a way to auto populate a cell whenever I enter data in a row? For example, let's say I am adding information to columns B and C (no specific order) for row #1, and whenever I provide this information, I would like column A to auto populate with the Study ID (the study ID will be the same for all rows). Thanks","categoryID":322,"dateInserted":"2022-11-07T18:05:37+00:00","dateUpdated":null,"dateLastComment":"2022-11-07T19:34:46+00:00","insertUserID":154015,"insertUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-07T18:43:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-11-08T01:17:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":15,"score":null,"hot":3335696423,"url":"https:\/\/community.smartsheet.com\/discussion\/97452\/is-there-a-way-to-auto-populate-a-cell-whenever-i-enter-data-in-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97452\/is-there-a-way-to-auto-populate-a-cell-whenever-i-enter-data-in-a-row","format":"Rich","lastPost":{"discussionID":97452,"commentID":350234,"name":"Re: Is there a way to auto populate a cell whenever I enter data in a row?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350234#Comment_350234","dateInserted":"2022-11-07T19:34:46+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-11-08T01:17:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XSMOG30GGW15\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-07T18:43:24+00:00","dateAnswered":"2022-11-07T18:22:42+00:00","acceptedAnswers":[{"commentID":350221,"body":"

Add this formula to the \"Study ID\" column.<\/p>

It checks if either Name or Description is not blank.<\/p>

=if(or(not(isblank(Name@row)),not(isblank(Description@row))),\"STUDY NUMBER<\/strong>\",\"\")<\/p>

Just to change \"study number\" by the number you want. <\/p>

I fyou want both column \"Name\" and \"Description\" to be filled before showing the Study number, use this formula:<\/p>

=if(AND<\/strong>(not(isblank(Name@row)),not(isblank(Description@row))),\"STUDY NUMBER<\/strong>\",\"\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 18:43:24","updateUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-07T18:43:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":97423,"type":"question","name":"Removing ' from cells","excerpt":"Hello, I imported an Excel spreadsheet containing a column of identification numbers that are 6 digits in length. When I tried to set up an index\/match formula using the values in that column, I got a \"no match\" error. After a little research, I discovered there is a single quote at the beginning of each ID number. I've…","categoryID":322,"dateInserted":"2022-11-07T00:23:28+00:00","dateUpdated":"2022-11-07T13:01:54+00:00","dateLastComment":"2022-11-07T16:57:02+00:00","insertUserID":135684,"insertUser":{"userID":135684,"name":"Khari Shiver","url":"https:\/\/community.smartsheet.com\/profile\/Khari%20Shiver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-07T16:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":135684,"lastUser":{"userID":135684,"name":"Khari Shiver","url":"https:\/\/community.smartsheet.com\/profile\/Khari%20Shiver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-07T16:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3335622030,"url":"https:\/\/community.smartsheet.com\/discussion\/97423\/removing-from-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97423\/removing-from-cells","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":97423,"commentID":350176,"name":"Re: Removing ' from cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/350176#Comment_350176","dateInserted":"2022-11-07T16:57:02+00:00","insertUserID":135684,"insertUser":{"userID":135684,"name":"Khari Shiver","url":"https:\/\/community.smartsheet.com\/profile\/Khari%20Shiver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-07T16:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-07T16:57:16+00:00","dateAnswered":"2022-11-07T13:00:53+00:00","acceptedAnswers":[{"commentID":350128,"body":"

IF you make a column with =VALUE([Imported data]@row) as formula, it willconvert the text to number.<\/p>

you can then copy\/paste that elsewhere<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-11-07 16:57:16","updateUser":{"userID":135684,"name":"Khari Shiver","url":"https:\/\/community.smartsheet.com\/profile\/Khari%20Shiver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-11-07T16:56:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">