公式和函数

30\",\">45\",\">90\",\">180\"}) I am entering this formula in the column \"Equipment Date Range\" and validating the data on column \"Days…","categoryID":322,"dateInserted":"2020-03-28T05:34:40+00:00","dateUpdated":null,"dateLastComment":"2020-03-31T09:58:18+00:00","insertUserID":119968,"insertUser":{"userID":119968,"name":"Iris Fuentes","url":"https:\/\/community.smartsheet.com\/profile\/Iris%20Fuentes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nB5UV6VYA5H58.png","dateLastActive":"2023-02-02T14:14:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-05-30T08:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":1592,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/66991\/need-help-with-creating-aging-buckets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66991\/need-help-with-creating-aging-buckets","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/469\/MNN2LW0MVG2J.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-31T13:47:52+00:00","dateAnswered":"2020-03-31T09:58:18+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":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":66984,"type":"question","name":"Help with cross sheet references.","excerpt":"Good morning, I am looking to pull the data in a cell if two other criteria are met in other cells in the same row. for example, I have a sheet called Daily reporting that is receiving form submissions. I want to pull the text in [Quality-Details] if [Column17] is equal to today AND [Value Stream Leader] is equal to Sergio…","categoryID":322,"dateInserted":"2020-03-27T19:14:47+00:00","dateUpdated":null,"dateLastComment":"2020-03-31T09:30:39+00:00","insertUserID":119959,"insertUser":{"userID":119959,"name":"Dave Moe","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20Moe","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xMNdMZBz5Lw!zXFcszRhyvo!qJ30_IoggER","dateLastActive":"2020-03-31T18:11:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-05T23:45:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":78,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/66984\/help-with-cross-sheet-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66984\/help-with-cross-sheet-references","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-30T13:44:28+00:00","dateAnswered":"2020-03-30T07:06:04+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":[],"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":66965,"type":"question","name":"SUMIF\/SUMIFS based on criteria","excerpt":"Hi! How do I sum a specific category (Primary Column) with reference to a separate sheet. I keep getting multiple errors:","categoryID":322,"dateInserted":"2020-03-27T06:55:39+00:00","dateUpdated":null,"dateLastComment":"2020-03-31T07:49:51+00:00","insertUserID":119710,"insertUser":{"userID":119710,"name":"Jessintha Nathan","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jessintha%20Nathan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-30T04:46:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-05-30T08:34:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":75,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/66965\/sumif-sumifs-based-on-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/66965\/sumif-sumifs-based-on-criteria","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/332\/RGPFM8JD7HIF.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":67033,"type":"discussion","name":"Adding a Column in a Cross Sheet Reference Range on VLOOKUP","excerpt":"I'm exploring changing several of my more complex Smartsheets to rely less on links and more on data tables that are accessed by other sheets using VLOOKUP functions. Everything was fine until I needed to add a new column on one of the data tables and discovered that the named ranges that use that table don't automatically…","categoryID":322,"dateInserted":"2020-03-30T22:03:26+00:00","dateUpdated":null,"dateLastComment":"2020-03-31T06:17:21+00:00","insertUserID":459,"insertUser":{"userID":459,"name":"Jim Hook","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Hook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/28\/n9d28abcc5c5c53d330f96b33667ff30d.png","dateLastActive":"2022-08-19T17:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-05T23:45:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":146,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/67033\/adding-a-column-in-a-cross-sheet-reference-range-on-vlookup","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67033\/adding-a-column-in-a-cross-sheet-reference-range-on-vlookup","format":"rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":67035,"type":"question","name":"If Status = \"DNR Request - Approved\" or \"MRS Request Approved\" Then formula question...","excerpt":"In an effort to track the amount of time from submission to completion I'd like to have a formula help populate the [Actual Completion Date] by using the following logical expression...however I'm not getting this to work. If Status = \"DNR Request - Approved\" or \"MRS Request Approved\" then [Actual Completion Date] =…","categoryID":322,"dateInserted":"2020-03-30T22:50:09+00:00","dateUpdated":null,"dateLastComment":"2020-03-31T05:56:56+00:00","insertUserID":76066,"insertUser":{"userID":76066,"name":"Jed Rusyniak","url":"https:\/\/community.smartsheet.com\/profile\/Jed%20Rusyniak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/ee\/78\/nee7870baf1e5832258cc68ae70eb674a.JPG","dateLastActive":"2023-05-12T16:12:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-05T23:45:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":76,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/67035\/if-status-dnr-request-approved-or-mrs-request-approved-then-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67035\/if-status-dnr-request-approved-or-mrs-request-approved-then-formula-question","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/662\/FV3JEJJGCUVY.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ss_help.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":67023,"type":"question","name":"Using Join with Logic","excerpt":"Is there a way in Smartsheet to combine the data in the rows below AND include the Column Headers AND exclude the \"No Impact\" Status? The end result should look something like this:","categoryID":322,"dateInserted":"2020-03-30T18:00:42+00:00","dateUpdated":null,"dateLastComment":"2020-03-30T19:10:05+00:00","insertUserID":81891,"insertUser":{"userID":81891,"name":"Donni Matthew","url":"https:\/\/community.smartsheet.com\/profile\/Donni%20Matthew","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zANfs-BDx3Q!c5HYx1m6w_w!P1OHUf95IWs","dateLastActive":"2023-04-27T16:15:08+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":"2023-06-05T13:34:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":88,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/67023\/using-join-with-logic","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67023\/using-join-with-logic","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/383\/3MV9PPWUTC5Z.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"JoinQuestion.jpg"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}">

帮助文章参考资料欧宝体育app官方888