公式和函数

= 0.9, AND([Actual Completion Percentage %]@row >= 0, [Baseline Start]@row > TODAY())), \"Green\", IF(OR([Schedule Variance]@row >= 0.8, IF(OR([Schedule Variance]@row < 0.9, AND([Baseline Start]@row < TODAY(),…","categoryID":322,"dateInserted":"2022-08-04T12:29:39+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T12:29:39+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":null,"lastUserID":125760,"lastUser":{"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":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":13,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/93915\/ryg-formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93915\/ryg-formula-question","format":"Rich","groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/77X9G7DL9P1E\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","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":93686,"type":"question","name":"Calculating completion date from multiple turn around time and date assigned","excerpt":"Hi All, I have created a workload management sheet. Within the sheet 1 column is for Turn Around Times (there are multiple) and 1 column is for Date Assigned. I need to calculate the Completion Date from the Turn Around Time and Date Assigned: Date Assigned + Turn around Time = X. What is the best formula to use? Thank…","categoryID":322,"dateInserted":"2022-07-28T13:35:31+00:00","dateUpdated":"2022-07-28T13:36:30+00:00","dateLastComment":"2022-08-04T12:28:27+00:00","insertUserID":150776,"insertUser":{"userID":150776,"name":"Lyn C","url":"https:\/\/community.smartsheet.com\/profile\/Lyn%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T15:47:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150776,"lastUserID":150776,"lastUser":{"userID":150776,"name":"Lyn C","url":"https:\/\/community.smartsheet.com\/profile\/Lyn%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-05T15:47:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":1,"hot":3318632938,"url":"https:\/\/community.smartsheet.com\/discussion\/93686\/calculating-completion-date-from-multiple-turn-around-time-and-date-assigned","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93686\/calculating-completion-date-from-multiple-turn-around-time-and-date-assigned","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-28T16:36: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":[],"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":93869,"type":"question","name":"Is there a way to see how many cell links I have in a grid?","excerpt":"I have some roll up sheets that hold the main data we use in the business. I regularly get the message that I am either approaching or going over the limit for links. I actively manage by clearing links on old completed data. But I was wondering if there is a way to quickly see the number of links there is on the sheet?…","categoryID":322,"dateInserted":"2022-08-03T09:14:30+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T11:36:44+00:00","insertUserID":126199,"insertUser":{"userID":126199,"name":"Greg Peddell-Grant","url":"https:\/\/community.smartsheet.com\/profile\/Greg%20Peddell-Grant","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7hlWeycbVzo!wc9UMFSFDHo!5YcG323hOPe","dateLastActive":"2022-08-03T10:11:57+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":3,"countViews":8,"score":null,"hot":3319132874,"url":"https:\/\/community.smartsheet.com\/discussion\/93869\/is-there-a-way-to-see-how-many-cell-links-i-have-in-a-grid","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93869\/is-there-a-way-to-see-how-many-cell-links-i-have-in-a-grid","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-03T10:08: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":[],"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":83931,"type":"question","name":"How can I set up a field with multiple entries in a form?","excerpt":"I need to create a field that has multiple entries in a form. I prefer not to create several columns (I need the respondents to make 7 entries, hence 7 columns should be created). Does anyone have a suggestion on how to do that?","categoryID":322,"dateInserted":"2021-10-12T12:47:39+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T11:26:06+00:00","insertUserID":140693,"insertUser":{"userID":140693,"name":"User251","title":"","url":"https:\/\/community.smartsheet.com\/profile\/User251","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-15T15:52:11+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":9,"countViews":73,"score":null,"hot":3293660625,"url":"https:\/\/community.smartsheet.com\/discussion\/83931\/how-can-i-set-up-a-field-with-multiple-entries-in-a-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/83931\/how-can-i-set-up-a-field-with-multiple-entries-in-a-form","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-24T16:40:06+00:00","dateAnswered":"2021-10-13T12:56:03+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":37911,"type":"discussion","name":"Date Modified","excerpt":"I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to \"complete\". I can do that easily with a filter - but I want to cull the entries before a specific date. I have a Report that uses the 'is greater than-date modified' but I get results from all…","categoryID":322,"dateInserted":"2018-12-20T00:18:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-08-04T10:55:20+00:00","insertUserID":72761,"insertUser":{"userID":72761,"name":"CamCrichton","url":"https:\/\/community.smartsheet.com\/profile\/CamCrichton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-19T03:07:09+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":17,"countViews":3504,"score":null,"hot":3204885836,"url":"https:\/\/community.smartsheet.com\/discussion\/37911\/date-modified","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37911\/date-modified","format":"Html","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":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"}],"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":93909,"type":"question","name":"Help with CONTAINS formula","excerpt":"Hi, I currently have a formula that is looking for a value in one cell and if it matches another it throws out a yes\/no. What I want to do is amend it so it looks for certain text and have it throw out a yes\/no if it matches the other cell value. Formula is: =IF(AND([ILG (min)(mm)]@row <= 0.249, [Finish (Outer plating…","categoryID":322,"dateInserted":"2022-08-04T08:03:20+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T10:46:55+00:00","insertUserID":151012,"insertUser":{"userID":151012,"name":"James Yewen","url":"https:\/\/community.smartsheet.com\/profile\/James%20Yewen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T10:15:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":134589,"lastUser":{"userID":134589,"name":"Kaveri Vipat","url":"https:\/\/community.smartsheet.com\/profile\/Kaveri%20Vipat","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!AVjTAAjmETQ!HWDTX8i_ihQ!T5Nvnd_zzas","dateLastActive":"2022-08-04T11:08:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":9,"score":null,"hot":3319210815,"url":"https:\/\/community.smartsheet.com\/discussion\/93909\/help-with-contains-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93909\/help-with-contains-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/URJC5GD0BJUZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-04T10:46:55+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":93889,"type":"question","name":"Nested formula to present the most recent KPI value from a row","excerpt":"I am trying to pull the most recent month's value to the 'Current Month Data' cell to use for Dashboard Widgets that will only present the Goal and Current Month Data. There are 30+ KPI values that need to have the latest month's value, and I'm stumped on how to build the nested formula to make it work. The same formula…","categoryID":322,"dateInserted":"2022-08-03T17:57:41+00:00","dateUpdated":"2022-08-03T17:59:25+00:00","dateLastComment":"2022-08-04T08:00:53+00:00","insertUserID":148172,"insertUser":{"userID":148172,"name":"ACB","url":"https:\/\/community.smartsheet.com\/profile\/ACB","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!4Skp-N_fUks!pekoaR_ssas!z2_WJ4o6i9H","dateLastActive":"2022-08-03T22:11:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":148172,"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":14,"score":null,"hot":3319150114,"url":"https:\/\/community.smartsheet.com\/discussion\/93889\/nested-formula-to-present-the-most-recent-kpi-value-from-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93889\/nested-formula-to-present-the-most-recent-kpi-value-from-a-row","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/NRILAK0WZ88B\/per-month-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"per month.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-04T08:00:53+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":93900,"type":"question","name":"Report showing Jira hierarchy","excerpt":"We've setup the Jira connector and sheet indenting is correct. How can we have the same hierarchy setup in reports? When I group by epic all subtasks fall off... I don't see the option to group by Category which is available from other reports. Thank you!","categoryID":322,"dateInserted":"2022-08-03T20:54:39+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T07:26:45+00:00","insertUserID":142495,"insertUser":{"userID":142495,"name":"KLoomis","url":"https:\/\/community.smartsheet.com\/profile\/KLoomis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T21:23:26+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":1,"countViews":10,"score":null,"hot":3319158684,"url":"https:\/\/community.smartsheet.com\/discussion\/93900\/report-showing-jira-hierarchy","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93900\/report-showing-jira-hierarchy","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-04T07:26:45+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":265,"urlcode":"Reports","name":"Reports"},{"tagID":450,"urlcode":"jira-connector","name":"Jira Connector"}],"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":93905,"type":"question","name":"IF, Then Formula","excerpt":"I need to figure out how to put together an \"IF, Then\" formula based on dates & selections from a drop down. One column is \"Project\". There is a drop down list of projects to choose from. The next column has the \"Live Date\" of the project. The column after has the \"Kick Off Date\" for the project. If the number of days from…","categoryID":322,"dateInserted":"2022-08-04T02:57:19+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T07:21:59+00:00","insertUserID":151007,"insertUser":{"userID":151007,"name":"sver","url":"https:\/\/community.smartsheet.com\/profile\/sver","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T20:05:51+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":15,"score":null,"hot":3319180158,"url":"https:\/\/community.smartsheet.com\/discussion\/93905\/if-then-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93905\/if-then-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-08-04T07:21: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":[],"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":93548,"type":"question","name":"Combine data from parent\/child rows into a single row","excerpt":"Hi, I would like to pull data from parent and child rows into a single row. I only want to display specific columns, so have been trying to do this using a report. In the first column, I want to display the data from the parent cell. The other columns would have data from the child cells. What I currently have is this:…","categoryID":322,"dateInserted":"2022-07-25T08:10:16+00:00","dateUpdated":null,"dateLastComment":"2022-08-04T05:07:17+00:00","insertUserID":150621,"insertUser":{"userID":150621,"name":"MrChris","url":"https:\/\/community.smartsheet.com\/profile\/MrChris","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T05:05:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":150621,"lastUser":{"userID":150621,"name":"MrChris","url":"https:\/\/community.smartsheet.com\/profile\/MrChris","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-04T05:05:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":20,"score":null,"hot":3318328053,"url":"https:\/\/community.smartsheet.com\/discussion\/93548\/combine-data-from-parent-child-rows-into-a-single-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93548\/combine-data-from-parent-child-rows-into-a-single-row","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/68ZX1OU7EFMB\/screen-shot-2022-07-25-at-6-05-47-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":""},"alt":"Screen Shot 2022-07-25 at 6.05.47 pm.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-07-28T08:20:45+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

帮助文章资源欧宝体育app官方888