公式

\"\"), \", \") My question: Is…","categoryID":322,"dateInserted":"2019-11-12T05:28:03+00:00","dateUpdated":"2022-06-15T13:08:14+00:00","dateLastComment":"2022-06-15T08:09:57+00:00","insertUserID":93931,"insertUser":{"userID":93931,"name":"anna_ashby","url":"https:\/\/community.smartsheet.com\/profile\/anna_ashby","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-23T13:31:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":3696,"lastUser":{"userID":3696,"name":"Maaik Meijerink","url":"https:\/\/community.smartsheet.com\/profile\/Maaik%20Meijerink","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/8b\/13\/n8b1398d67fe5121c5d6145d9907fae1b.jpg","dateLastActive":"2022-06-15T08:21:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":263,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/62561\/sort-data-from-a-join-collect-formula-within-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62561\/sort-data-from-a-join-collect-formula-within-a-cell","format":"Html","groupID":null,"statusID":8,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":88375,"type":"question","name":"Formula to find the average word used in a column","excerpt":"Hi, Is there a formula I can use to find the average \"word\" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann","categoryID":322,"dateInserted":"2022-02-25T06:26:39+00:00","dateUpdated":null,"dateLastComment":"2022-06-15T02:14:45+00:00","insertUserID":145296,"insertUser":{"userID":145296,"name":"Ann11","url":"https:\/\/community.smartsheet.com\/profile\/Ann11","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-16T22:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145296,"lastUser":{"userID":145296,"name":"Ann11","url":"https:\/\/community.smartsheet.com\/profile\/Ann11","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-16T22:56:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":83,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/88375\/formula-to-find-the-average-word-used-in-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/88375\/formula-to-find-the-average-word-used-in-a-column","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JZIA8688KR2P\/screen-shot-2022-02-25-at-4-53-19-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Screen Shot 2022-02-25 at 4.53.19 pm.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-02-28T12:11:49+00:00","dateAnswered":"2022-02-28T11:53:43+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":92088,"type":"question","name":"Why isn't our column formula updating on its own?","excerpt":"In our column formula, we have a date formula based on TODAY(), however, it does not seem to update automatically when the month changes. How do I get it to update automatically at the beginning of the month?","categoryID":322,"dateInserted":"2022-06-14T15:24:45+00:00","dateUpdated":null,"dateLastComment":"2022-06-14T19:53:33+00:00","insertUserID":148987,"insertUser":{"userID":148987,"name":"EZayas","url":"https:\/\/community.smartsheet.com\/profile\/EZayas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-14T19:59:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-06-16T20:41:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92088\/why-isnt-our-column-formula-updating-on-its-own","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92088\/why-isnt-our-column-formula-updating-on-its-own","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-14T19:59:55+00:00","dateAnswered":"2022-06-14T19:53:33+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":333,"urlcode":"Workflows in Smartsheet","name":"Workflows in Smartsheet"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":92074,"type":"question","name":"Latest Date Formula","excerpt":"Hi I want to find the latest date a review was done on a file number. Multiple reviews could have been done on the same file so, I only want the latest date. I have used: =INDEX(MAX({01.SHEET: File Review Range 1}, MATCH([Matter Number]@row, {01.SHEET: File Review Range 2})), 0) as I am referencing the File Review sheet…","categoryID":322,"dateInserted":"2022-06-14T13:28:21+00:00","dateUpdated":null,"dateLastComment":"2022-06-14T16:04:03+00:00","insertUserID":125322,"insertUser":{"userID":125322,"name":"Cheryl Collins","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Collins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ujDUd8trmpQ!HMFV36dbhPo!OB9bg9sjUrN","dateLastActive":"2022-06-14T16:03:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":125322,"lastUser":{"userID":125322,"name":"Cheryl Collins","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Collins","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ujDUd8trmpQ!HMFV36dbhPo!OB9bg9sjUrN","dateLastActive":"2022-06-14T16:03:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":6,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/92074\/latest-date-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92074\/latest-date-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-14T16:03:26+00:00","dateAnswered":"2022-06-14T13:36:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":91883,"type":"question","name":"Hi All, I tried a nested IF AND & IF OR formula but it is showing as #UNPARSEABLE error. pls help.","excerpt":"Below is the formula I am using. =VALUE(IFERROR (IF(AND(Level@row = 1, (IF (OR(column@row = \"Test 1o1\", column@row = \"Test 2 of 1\",column@row = \"Test 3 of 1\", \"31\"),(IF (OR(column@row = \"Test 1o1\", column@row = \"Test 2 of 1\",column@row = \"Test 3 of 1\", \"41\"),(IF (OR(column@row = \"Test 1o1\", column@row = \"Test 2 of…","categoryID":322,"dateInserted":"2022-06-08T11:50:09+00:00","dateUpdated":null,"dateLastComment":"2022-06-14T13:07:52+00:00","insertUserID":122925,"insertUser":{"userID":122925,"name":"Mindfull","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mindfull","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-16T13:07:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-06-16T20:41:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":22,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/91883\/hi-all-i-tried-a-nested-if-and-if-or-formula-but-it-is-showing-as-unparseable-error-pls-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91883\/hi-all-i-tried-a-nested-if-and-if-or-formula-but-it-is-showing-as-unparseable-error-pls-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-13T13:16:02+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":91961,"type":"question","name":"Reversing WEEKNUMBER Function","excerpt":"Hi all, I have a few values corresponding to different dates, and I would like to group these dates by their respective weeks. What I am thinking of doing is using the WEEKNUMBER function to generate what week they are in, and then grouping them using this number. Additionally however, I would like to group them by the…","categoryID":322,"dateInserted":"2022-06-09T19:18:36+00:00","dateUpdated":null,"dateLastComment":"2022-06-14T10:30:38+00:00","insertUserID":148853,"insertUser":{"userID":148853,"name":"Muhammad","url":"https:\/\/community.smartsheet.com\/profile\/Muhammad","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-14T11:41:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-16T22:08:01+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/91961\/reversing-weeknumber-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91961\/reversing-weeknumber-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-14T11:41:29+00:00","dateAnswered":"2022-06-14T10:30:38+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":91888,"type":"question","name":"Reference date above to carry on sequence when row moved","excerpt":"Hi Sorry to go into an old post but this is what I want, to look at the dates. I want to look at moving rows which have sequential dates based on planning. =WORKDAY([Online Date]248, 1, {Holidays Range 2}) I also want this to inherit from the date above to repopulate the sequence in order as shown Currently, if we move a…","categoryID":322,"dateInserted":"2022-06-08T13:55:40+00:00","dateUpdated":null,"dateLastComment":"2022-06-14T09:15:38+00:00","insertUserID":129989,"insertUser":{"userID":129989,"name":"David Clunie","url":"https:\/\/community.smartsheet.com\/profile\/David%20Clunie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GigaDmcJxodi52R9lxzlajJ3fpq6-OKeCtKxwh90g=s96-c","dateLastActive":"2022-06-15T19:03:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-06-16T22:08:01+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":12,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/91888\/reference-date-above-to-carry-on-sequence-when-row-moved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91888\/reference-date-above-to-carry-on-sequence-when-row-moved","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-13T10:15:39+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">