公式和函数

0.9 green '<0.8 red between 0.8 and 0.9 yellow =IFERROR(AVG(CHILDREN()), IF([Actual Completion Percentage %]@row = 1, \"\", IF(AND(Variance@row > 1, [Actual Completion Percentage %]@row < 1), 0), IF(AND(Variance@row > 1,…","categoryID":322,"dateInserted":"2022-06-15T21:41:42+00:00","dateUpdated":"2022-06-16T11:07:36+00:00","dateLastComment":"2022-08-04T15:19:13+00:00","insertUserID":125760,"insertUser":{"userID":125760,"name":"Melissa Torrez","url":"https:\/\/community.smartsheet.com\/profile\/Melissa%20Torrez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T17:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":148800,"lastUser":{"userID":148800,"name":"HeatherD.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/HeatherD.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!n0lGP-EXATs!bB9HG8ENRvs!xyI8qfE88hc","dateLastActive":"2022-08-05T14:54:19+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":46,"score":null,"hot":3314961055,"url":"https:\/\/community.smartsheet.com\/discussion\/92230\/health-formula-for-schedule-variance","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92230\/health-formula-for-schedule-variance","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5A8JS55YTAKO\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-17T21:26:46+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":93922,"type":"question","name":"What formula would I use to read a date from another sheet?","excerpt":"I have a sheet that collects dates in a column \"CO Internal Target\", I want to be able to list that date on another sheet with a formula. It should be able to read the \"Studio Code\". Both of the columns are on both sheets. The sheet that I am wanting to read from is the \"Location Tracker - SS\", the sheet that it is going…","categoryID":322,"dateInserted":"2022-08-04T14:43:58+00:00","dateUpdated":"2022-08-04T14:51:59+00:00","dateLastComment":"2022-08-04T15:19:11+00:00","insertUserID":151023,"insertUser":{"userID":151023,"name":"haley brianne","url":"https:\/\/community.smartsheet.com\/profile\/haley%20brianne","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ctlTZ_S497o!xZHTMZjnM3w!tcsfrsbYnAv","dateLastActive":"2022-08-04T15:16:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":151023,"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-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":22,"score":null,"hot":3319252989,"url":"https:\/\/community.smartsheet.com\/discussion\/93922\/what-formula-would-i-use-to-read-a-date-from-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93922\/what-formula-would-i-use-to-read-a-date-from-another-sheet","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-04T15:17:13+00:00","dateAnswered":"2022-08-04T15:15:59+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}],"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":93832,"type":"question","name":"COUNTIF matching instances, or alternative IF(ISBLANK workaround?","excerpt":"Hello! I'm struggling with syntax and can't figure out why this isn't working. I have two columns [Total] and [Inspected]. I'm using countif in the first row of [Column4] to count the number of instances both columns have matching values, but it isn't giving me the correct count. Eventually, I'd like to build upon it to…","categoryID":322,"dateInserted":"2022-08-02T15:31:36+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T15:19:02+00:00","insertUserID":125143,"insertUser":{"userID":125143,"name":"Jen Castillo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20Castillo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T14:30:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":125143,"lastUser":{"userID":125143,"name":"Jen Castillo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jen%20Castillo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T14:30:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3319081838,"url":"https:\/\/community.smartsheet.com\/discussion\/93832\/countif-matching-instances-or-alternative-if-isblank-workaround","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93832\/countif-matching-instances-or-alternative-if-isblank-workaround","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CT9MOY0JIQCU\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-04T15:19:06+00:00","dateAnswered":"2022-08-02T17:05:15+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":93767,"type":"question","name":"COUNTIFS Errors","excerpt":"I'm trying to create a Sheet Summary field formula that will count up the number of \"Yes\" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls within a given month\/year range. This one seems to be working... I think: =IFERROR((COUNTIFS(OTD:OTD, OR(@cell = \"Yes\", @cell =…","categoryID":322,"dateInserted":"2022-07-29T21:46:58+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T14:56:28+00:00","insertUserID":134452,"insertUser":{"userID":134452,"name":"Katherine Wilgruber","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Wilgruber","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T14:52:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":134452,"lastUser":{"userID":134452,"name":"Katherine Wilgruber","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Wilgruber","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T14:52:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3318757406,"url":"https:\/\/community.smartsheet.com\/discussion\/93767\/countifs-errors","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93767\/countifs-errors","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-01T12:03:40+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"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":339,"urlcode":"error","name":"Error"}],"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":93801,"type":"question","name":"Formatting Dates","excerpt":"I am copy and pasting reference data that contains dates as text. How can I link to a field and get it to format it as a date. The data looks like this Tuesday, August 16, 2022, but Smartsheet does not recognize it as a date. I tried this =[OPD Data]24{DATE(2021,5,5)}","categoryID":322,"dateInserted":"2022-08-01T16:51:41+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T14:41:18+00:00","insertUserID":150675,"insertUser":{"userID":150675,"name":"smeyermmec","url":"https:\/\/community.smartsheet.com\/profile\/smeyermmec","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-02T21:56:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126598,"lastUser":{"userID":126598,"name":"Paul McGuinness","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20McGuinness","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T15:07:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3318997379,"url":"https:\/\/community.smartsheet.com\/discussion\/93801\/formatting-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93801\/formatting-dates","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-04T14:41: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":[],"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":93859,"type":"question","name":"COUNTIF:CONTAINS formula help","excerpt":"Hello! I'm working on a formula to capture project start dates in each month. The formula I'm using is as follows: =COUNTIFS({Target Start Date}, (CONTAINS(\"January\", @cell)), {Status}, =\"In Progress\", {Type}, =\"Enterprise\") I'm not getting an error message with this formula but it doesn't appear to be capturing any of the…","categoryID":322,"dateInserted":"2022-08-02T20:26:02+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T13:43:39+00:00","insertUserID":145434,"insertUser":{"userID":145434,"name":"anuelle","url":"https:\/\/community.smartsheet.com\/profile\/anuelle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zLdoM0MHzLM!WlkqHx_qWSs!BKaDpVVtD3z","dateLastActive":"2022-08-05T14:53:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":145434,"lastUser":{"userID":145434,"name":"anuelle","url":"https:\/\/community.smartsheet.com\/profile\/anuelle","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zLdoM0MHzLM!WlkqHx_qWSs!BKaDpVVtD3z","dateLastActive":"2022-08-05T14:53:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3319093781,"url":"https:\/\/community.smartsheet.com\/discussion\/93859\/countif-contains-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93859\/countif-contains-formula-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-03T12:17:40+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":93845,"type":"question","name":"Want to verify cells are equal, but getting reversed 'true' 'false' values in IF() statement...","excerpt":"I have a large SmartSheet that contains deposit information for my company plus others we do billing for. Since payments come in long after the service date in healthcare, I may get an outlier payment for a company that is no longer active in current year, but need to process. I've created a cell 'All Deposits' that is the…","categoryID":322,"dateInserted":"2022-08-02T18:46:06+00:00","dateUpdated":"2022-08-02T18:54:13+00:00","dateLastComment":"2022-08-04T13:09:06+00:00","insertUserID":150946,"insertUser":{"userID":150946,"name":"Stacey C","url":"https:\/\/community.smartsheet.com\/profile\/Stacey%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-03T15:50:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150946,"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-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3319085712,"url":"https:\/\/community.smartsheet.com\/discussion\/93845\/want-to-verify-cells-are-equal-but-getting-reversed-true-false-values-in-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93845\/want-to-verify-cells-are-equal-but-getting-reversed-true-false-values-in-if-statement","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-03T15:54:37+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":93815,"type":"question","name":"using index\/collect to gather data from 2 sheets","excerpt":"Hello - I have several budget sheets that use an \"index\/collect\" formula to grab information from a master data sheet. However, we are now moving some rows from the master data sheet to an archived master data sheet. Once that row is moved, all of the index\/collect cells are broken since the original row with the data is…","categoryID":322,"dateInserted":"2022-08-01T20:43:49+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T13:07:24+00:00","insertUserID":149874,"insertUser":{"userID":149874,"name":"LAO","url":"https:\/\/community.smartsheet.com\/profile\/LAO","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-06T04:11:46+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-08-06T13:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":25,"score":null,"hot":3319007473,"url":"https:\/\/community.smartsheet.com\/discussion\/93815\/using-index-collect-to-gather-data-from-2-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93815\/using-index-collect-to-gather-data-from-2-sheets","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-03T02:46:15+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":70359,"type":"question","name":"Multiple Criteria for INDEX\/MATCH or VLOOKUP?","excerpt":"Hello, I have been defeated while trying to reference another sheet and pull information that matches multiple criteria. I need to pull an Account Number that matches both a Vendor Name and Location Name. Essentially, I want to populate the account numbers for specific locations based on a particular vendor. I cannot add a…","categoryID":322,"dateInserted":"2020-08-04T20:23:36+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T12:57:16+00:00","insertUserID":98656,"insertUser":{"userID":98656,"name":"Jennifer Whitlock","url":"https:\/\/community.smartsheet.com\/profile\/Jennifer%20Whitlock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-08\/7b\/7b\/n7b7b476a2fd912eda85e3f838cd8c3dd.jpg","dateLastActive":"2021-09-15T19:22:29+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-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":30,"countViews":4045,"score":null,"hot":3256208452,"url":"https:\/\/community.smartsheet.com\/discussion\/70359\/multiple-criteria-for-index-match-or-vlookup","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70359\/multiple-criteria-for-index-match-or-vlookup","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T17:22:09+00:00","dateAnswered":"2020-08-05T16:44:20+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":93899,"type":"question","name":"Creating a Calculator","excerpt":"Hi All - I'm trying to create a calculator in SmartSheets. I'm envisioning it as a pseudo GUI that leverages data from different sheets that we've populated, whereby we input values into this calculator, and it calculates based on predefined equations. There's ways to get close to it through a form or directly in a sheet,…","categoryID":322,"dateInserted":"2022-08-03T20:22:39+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T12:54:23+00:00","insertUserID":116755,"insertUser":{"userID":116755,"name":"Mike Rini","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Rini","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7qFD-6EKX_o!7KdAe1VbTDw!eGBY2moMFCj","dateLastActive":"2022-08-05T17:08:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":116755,"lastUser":{"userID":116755,"name":"Mike Rini","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Rini","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7qFD-6EKX_o!7KdAe1VbTDw!eGBY2moMFCj","dateLastActive":"2022-08-05T17:08:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3319177022,"url":"https:\/\/community.smartsheet.com\/discussion\/93899\/creating-a-calculator","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93899\/creating-a-calculator","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-04T09:14:42+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":204,"urlcode":"Forms","name":"Forms"},{"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