是什么推动了你的工作过程?

参加我们的测试，了解您的过程能力，以及如何利用它来产生更大的影响。

把测试

领域探索

关于Smartsheet社区
快速浏览一下，看看登录的所有好处。

浏览讨论
看看最近有人分享了什么，加入那些你感兴趣的对话。

获得徽章+ Swag
让我们好好庆祝一下吧!现在加入，开始赚取积分，徽章和Smartsheet swag。

欢迎加入社区
找到快速提示，初学者常见问题，和我们的社区指南。如果您需要帮助，请给我们留言。

使用内容
找到您的核心Smartsheet应用程序的答案，添加ons和集成问题，在这里。

展示和讲述
分享和庆祝-无论是一个提升，一个新的Smartsheet解决方案，最佳实践或徽章。分享好消息，为他人加油!
TODAY(), \"Green\", IF(AND([End Date]@row <= TODAY(), [Start Date]@row < TODAY()), \"Red\", IF(NOT([Start Date]@row > TODAY(+7)), \"Yellow\", IF([Start Date]@row <= TODAY(), \"Green\"))))) Works great! I would…","categoryID":322,"dateInserted":"2022-10-18T21:51:23+00:00","dateUpdated":"2022-10-18T21:53:48+00:00","dateLastComment":"2022-10-21T08:56:44+00:00","insertUserID":153319,"insertUser":{"userID":153319,"name":"rachkh","url":"https:\/\/community.smartsheet.com\/profile\/rachkh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T22:19:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":153319,"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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":51,"score":null,"hot":3332475487,"url":"https:\/\/community.smartsheet.com\/discussion\/96758\/scheduled-health-rollup-using-red-yellow-green-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96758\/scheduled-health-rollup-using-red-yellow-green-formula","format":"Rich","lastPost":{"discussionID":96758,"commentID":348112,"name":"Re: Scheduled Health Rollup using \"Red Yellow Green\" formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348112#Comment_348112","dateInserted":"2022-10-21T08:56:44+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-10-18T22:48:51+00:00","dateAnswered":"2022-10-18T22:30:59+00:00","acceptedAnswers":[{"commentID":347708,"body":"

@rachkh<\/a>,<\/p>

The metric you show is exactly why I mentioned losing the ability to use discretion when a Health roll-up formula is in place. Many times folks don't want their roll-up to be forced. Someone may have a yellow item or two that's just not important enough to cause the project to roll-up to yellow.<\/p>

As far as a better equation: I don't know of a better one myself. I would be using the one you posted, but would couple it with the automation otherwise the roll-up will break once a row becomes a parent row. Unless of course you manually add the formula every time a row becomes a parent, but that manual effort and need to remember is not preferred or scalable.<\/p>

Remember automation runs regularly (every couple minutes or so), so you won't see the formula appear instantly when a row becomes a parent.<\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-18 22:48:51","updateUser":{"userID":153319,"name":"rachkh","url":"https:\/\/community.smartsheet.com\/profile\/rachkh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T22:19:50+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":96812,"type":"question","name":"Sumif Index Match multiple criteria","excerpt":"Hi, I would like to add the quantity in another sheet if they match 4 criteria in my sheet. For instance; I would like to add the quantity (from the Orders Sheet) of material ordered for each item in the Costing Sheet, to compare with what we costed on. Below is the Costing Sheet, so I would like to add up the quantities…","categoryID":322,"dateInserted":"2022-10-19T21:17:47+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T08:53:16+00:00","insertUserID":105591,"insertUser":{"userID":105591,"name":"Warren Labuschagne","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20Labuschagne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T21:27:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":105591,"lastUser":{"userID":105591,"name":"Warren Labuschagne","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20Labuschagne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T21:27:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3332557863,"url":"https:\/\/community.smartsheet.com\/discussion\/96812\/sumif-index-match-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96812\/sumif-index-match-multiple-criteria","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":96812,"commentID":348111,"name":"Re: Sumif Index Match multiple criteria","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348111#Comment_348111","dateInserted":"2022-10-21T08:53:16+00:00","insertUserID":105591,"insertUser":{"userID":105591,"name":"Warren Labuschagne","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20Labuschagne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T21:27:23+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":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HO9WA1HSYSDO\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T11:09:01+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-20 11:09:02","updateUser":{"userID":150366,"name":"Brucey","url":"https:\/\/community.smartsheet.com\/profile\/Brucey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pJMqqRYgrfs!WvsoXz5SX0s!vSmzWlrJyEc","dateLastActive":"2022-10-20T13:34:55+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"}]},{"discussionID":96827,"type":"question","name":"Assigning Contact Based on data in another sheet","excerpt":"Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian","categoryID":321,"dateInserted":"2022-10-20T14:48:15+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T08:36:00+00:00","insertUserID":153573,"insertUser":{"userID":153573,"name":"Gillian","url":"https:\/\/community.smartsheet.com\/profile\/Gillian","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2UtvfrY8Mfo!!nBfUikkOtPJ","dateLastActive":"2022-10-20T22:35:11+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":22,"score":null,"hot":3332621055,"url":"https:\/\/community.smartsheet.com\/discussion\/96827\/assigning-contact-based-on-data-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96827\/assigning-contact-based-on-data-in-another-sheet","format":"Rich","tagIDs":[204,247,254,334],"lastPost":{"discussionID":96827,"commentID":348110,"name":"Re: Assigning Contact Based on data in another sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348110#Comment_348110","dateInserted":"2022-10-21T08:36:00+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T15:08:12+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-20 15:08:12","updateUser":{"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-10-21T07:26:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":89169,"type":"question","name":"Formula to match and pull in information across multiple rows","excerpt":"I want to create a formula in Sheet 1 that looks at the information in a column in Sheet 1 and searches for matches in a specific column in Sheet 2. If a match is found in that column in any of the rows in Sheet 2, the formula will pull in information from another column in all rows in Sheet 2, not just from the row of the…","categoryID":322,"dateInserted":"2022-03-18T19:02:37+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T08:17:51+00:00","insertUserID":66916,"insertUser":{"userID":66916,"name":"Raquel Love","url":"https:\/\/community.smartsheet.com\/profile\/Raquel%20Love","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-10\/d0\/54\/nd054f98cfe64f290096f698e9dd3d8d6.JPG","dateLastActive":"2022-09-12T22:32:10+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":50,"score":1,"hot":3313972528,"url":"https:\/\/community.smartsheet.com\/discussion\/89169\/formula-to-match-and-pull-in-information-across-multiple-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89169\/formula-to-match-and-pull-in-information-across-multiple-rows","format":"Rich","lastPost":{"discussionID":89169,"commentID":348109,"name":"Re: Formula to match and pull in information across multiple rows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348109#Comment_348109","dateInserted":"2022-10-21T08:17:51+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-03-18T20:59:30+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"]},"discussions":[{"discussionID":96864,"type":"question","name":"Count Created Date within last month","excerpt":"Hi All, I want to use the formula in the Sheet Summary in my smartsheet to count the created date column for last month. I have tried the formula but it always return to 0; however, looking through the date I have 3 created last month. =COUNTIF([Date Created]:[Date Created], MONTH(TODAY())-1) Since I have 1 parent row with…","categoryID":322,"dateInserted":"2022-10-20T23:37:08+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T00:26:29+00:00","insertUserID":144090,"insertUser":{"userID":144090,"name":"Emi","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Emi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T02:43:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144090,"lastUser":{"userID":144090,"name":"Emi","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Emi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T02:43:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":3332621617,"url":"https:\/\/community.smartsheet.com\/discussion\/96864\/count-created-date-within-last-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96864\/count-created-date-within-last-month","format":"Rich","lastPost":{"discussionID":96864,"commentID":348099,"name":"Re: Count Created Date within last month","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348099#Comment_348099","dateInserted":"2022-10-21T00:26:29+00:00","insertUserID":144090,"insertUser":{"userID":144090,"name":"Emi","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Emi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T02:43:48+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":4,"attributes":{"question":{"status":"rejected","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":4,"name":"Rejected","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 08:15:50","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":96862,"type":"question","name":"How to use a Google Sheet attachment in Data Shuttle upload","excerpt":"Hi all- I’m trying to setup a Data Shuttle upload workflow to read the latest attachment to a sheet, where those attachments are Google Sheets. When I select Smartsheet Attachment as the source and point at the sheet with Google Sheet attachments, it errors and tells me there’s no valid files attached. Is this because…","categoryID":343,"dateInserted":"2022-10-20T22:21:40+00:00","dateUpdated":"2022-10-20T22:22:14+00:00","dateLastComment":"2022-10-20T22:21:40+00:00","insertUserID":140451,"insertUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-10-21T04:48:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":140451,"lastUserID":140451,"lastUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-10-21T04:48:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96862\/how-to-use-a-google-sheet-attachment-in-data-shuttle-upload","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96862\/how-to-use-a-google-sheet-attachment-in-data-shuttle-upload","format":"Rich","lastPost":{"discussionID":96862,"name":"How to use a Google Sheet attachment in Data Shuttle upload","url":"https:\/\/community.smartsheet.com\/discussion\/96862\/how-to-use-a-google-sheet-attachment-in-data-shuttle-upload","dateInserted":"2022-10-20T22:21:40+00:00","insertUserID":140451,"insertUser":{"userID":140451,"name":"Brian_Richardson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brian_Richardson","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3gsODavHSggzZ-xp1nf0UGuLXkegzF2uAZRanwGQ=s96-c","dateLastActive":"2022-10-21T04:48:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":96861,"type":"question","name":"Parent\/Child Hierarchy Formulas","excerpt":"Hi, I have a formula to figure out where I want the parent rows to increase by 1 each time, while the child rows maintain the same number as the parent. IE only the parent rows should increase to match the numbering convention. I'm trying to get the A.X to match what's in the right most column (as those will be deleted and…","categoryID":322,"dateInserted":"2022-10-20T22:12:07+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T22:12:07+00:00","insertUserID":153971,"insertUser":{"userID":153971,"name":"la3815","url":"https:\/\/community.smartsheet.com\/profile\/la3815","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T22:12:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153971,"lastUser":{"userID":153971,"name":"la3815","url":"https:\/\/community.smartsheet.com\/profile\/la3815","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T22:12:12+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\/96861\/parent-child-hierarchy-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96861\/parent-child-hierarchy-formulas","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":96861,"name":"Parent\/Child Hierarchy Formulas","url":"https:\/\/community.smartsheet.com\/discussion\/96861\/parent-child-hierarchy-formulas","dateInserted":"2022-10-20T22:12:07+00:00","insertUserID":153971,"insertUser":{"userID":153971,"name":"la3815","url":"https:\/\/community.smartsheet.com\/profile\/la3815","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T22:12:12+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":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TU5B0PUJJMXR\/screenshot-2022-10-20-170859.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2022-10-20 170859.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"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"}]},{"discussionID":96860,"type":"question","name":"Can INDEX \/ MATCH join more than one item?","excerpt":"The INDEX \/ MATCH works when I want to match each name with one team... but if I have all three names in one cell, can I get a return of all three teams associated with each name?","categoryID":322,"dateInserted":"2022-10-20T22:05:24+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T22:05:24+00:00","insertUserID":148626,"insertUser":{"userID":148626,"name":"Berto D","url":"https:\/\/community.smartsheet.com\/profile\/Berto%20D","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5dfZ-Xnfdb8!5EtYuWXiYHU!F1_6oGulnb-","dateLastActive":"2022-10-20T22:05:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148626,"lastUser":{"userID":148626,"name":"Berto D","url":"https:\/\/community.smartsheet.com\/profile\/Berto%20D","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5dfZ-Xnfdb8!5EtYuWXiYHU!F1_6oGulnb-","dateLastActive":"2022-10-20T22:05:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/96860\/can-index-match-join-more-than-one-item","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96860\/can-index-match-join-more-than-one-item","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":96860,"name":"Can INDEX \/ MATCH join more than one item?","url":"https:\/\/community.smartsheet.com\/discussion\/96860\/can-index-match-join-more-than-one-item","dateInserted":"2022-10-20T22:05:24+00:00","insertUserID":148626,"insertUser":{"userID":148626,"name":"Berto D","url":"https:\/\/community.smartsheet.com\/profile\/Berto%20D","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5dfZ-Xnfdb8!5EtYuWXiYHU!F1_6oGulnb-","dateLastActive":"2022-10-20T22:05:26+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":1,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/6TBRU2A4LF0K\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"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"}]},{"discussionID":96859,"type":"question","name":"Count dates within a column","excerpt":"I want a formula that will count how many lease expire in a given year. Some of the data in the column is 'na' or blank because it is not leased, but owned.","categoryID":322,"dateInserted":"2022-10-20T21:14:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-20T21:35:51+00:00","insertUserID":153970,"insertUser":{"userID":153970,"name":"JK1116","url":"https:\/\/community.smartsheet.com\/profile\/JK1116","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5EDCuS0XaWc!yUnFMtsn8T8!umK8Yg2dwm1","dateLastActive":"2022-10-20T21:40:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-20T22:34:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3332602841,"url":"https:\/\/community.smartsheet.com\/discussion\/96859\/count-dates-within-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96859\/count-dates-within-a-column","format":"Rich","lastPost":{"discussionID":96859,"commentID":348093,"name":"Re: Count dates within a column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348093#Comment_348093","dateInserted":"2022-10-20T21:35:51+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-20T22:34: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":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T21:35:51+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-20 21:35:51","updateUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-20T22:34:17+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":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">

探索。问。回答

找到与Smartsheet相关的所有点对点信息——从项目管理最佳实践到来自其他用户和Smartsheet专家的宝贵指导。

讨论表

TODAY(), \"Green\", IF(AND([End Date]@row <= TODAY(), [Start Date]@row < TODAY()), \"Red\", IF(NOT([Start Date]@row > TODAY(+7)), \"Yellow\", IF([Start Date]@row <= TODAY(), \"Green\"))))) Works great! I would…","categoryID":322,"dateInserted":"2022-10-18T21:51:23+00:00","dateUpdated":"2022-10-18T21:53:48+00:00","dateLastComment":"2022-10-21T08:56:44+00:00","insertUserID":153319,"insertUser":{"userID":153319,"name":"rachkh","url":"https:\/\/community.smartsheet.com\/profile\/rachkh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T22:19:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":153319,"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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":51,"score":null,"hot":3332475487,"url":"https:\/\/community.smartsheet.com\/discussion\/96758\/scheduled-health-rollup-using-red-yellow-green-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96758\/scheduled-health-rollup-using-red-yellow-green-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-18T22:48:51+00:00","dateAnswered":"2022-10-18T22:30: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":96812,"type":"question","name":"Sumif Index Match multiple criteria","excerpt":"Hi, I would like to add the quantity in another sheet if they match 4 criteria in my sheet. For instance; I would like to add the quantity (from the Orders Sheet) of material ordered for each item in the Costing Sheet, to compare with what we costed on. Below is the Costing Sheet, so I would like to add up the quantities…","categoryID":322,"dateInserted":"2022-10-19T21:17:47+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T08:53:16+00:00","insertUserID":105591,"insertUser":{"userID":105591,"name":"Warren Labuschagne","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20Labuschagne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T21:27:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":105591,"lastUser":{"userID":105591,"name":"Warren Labuschagne","url":"https:\/\/community.smartsheet.com\/profile\/Warren%20Labuschagne","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-20T21:27:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3332557863,"url":"https:\/\/community.smartsheet.com\/discussion\/96812\/sumif-index-match-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96812\/sumif-index-match-multiple-criteria","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HO9WA1HSYSDO\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T11:09:01+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":96827,"type":"question","name":"Assigning Contact Based on data in another sheet","excerpt":"Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian","categoryID":321,"dateInserted":"2022-10-20T14:48:15+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T08:36:00+00:00","insertUserID":153573,"insertUser":{"userID":153573,"name":"Gillian","url":"https:\/\/community.smartsheet.com\/profile\/Gillian","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2UtvfrY8Mfo!!nBfUikkOtPJ","dateLastActive":"2022-10-20T22:35:11+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":22,"score":null,"hot":3332621055,"url":"https:\/\/community.smartsheet.com\/discussion\/96827\/assigning-contact-based-on-data-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96827\/assigning-contact-based-on-data-in-another-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T15:08:12+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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":89169,"type":"question","name":"Formula to match and pull in information across multiple rows","excerpt":"I want to create a formula in Sheet 1 that looks at the information in a column in Sheet 1 and searches for matches in a specific column in Sheet 2. If a match is found in that column in any of the rows in Sheet 2, the formula will pull in information from another column in all rows in Sheet 2, not just from the row of the…","categoryID":322,"dateInserted":"2022-03-18T19:02:37+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T08:17:51+00:00","insertUserID":66916,"insertUser":{"userID":66916,"name":"Raquel Love","url":"https:\/\/community.smartsheet.com\/profile\/Raquel%20Love","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-10\/d0\/54\/nd054f98cfe64f290096f698e9dd3d8d6.JPG","dateLastActive":"2022-09-12T22:32:10+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\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T09:01:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":50,"score":1,"hot":3313972528,"url":"https:\/\/community.smartsheet.com\/discussion\/89169\/formula-to-match-and-pull-in-information-across-multiple-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89169\/formula-to-match-and-pull-in-information-across-multiple-rows","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-03-18T20:59:30+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":96711,"type":"question","name":"Sum formula not working","excerpt":"I want to sum all the values in the yellow columns, however it's not happening with the usual sum function🤷‍♀️ The values in the yellow columns are all from calculations of IF(AND()) formula, as below: =IF(AND([Price Type]@row = \"Regular\", [23rd Total Radiology 30 Jan - 2 Feb]@row = 1), 1800, \"//www.santa-greenland.com/community/\") + IF(AND([Price…","categoryID":322,"dateInserted":"2022-10-18T04:54:21+00:00","dateUpdated":"2022-10-18T04:59:42+00:00","dateLastComment":"2022-10-21T04:47:50+00:00","insertUserID":150911,"insertUser":{"userID":150911,"name":"Donna B.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Donna%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T08:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":150911,"lastUserID":150911,"lastUser":{"userID":150911,"name":"Donna B.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Donna%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T08:49:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":39,"score":null,"hot":3332399531,"url":"https:\/\/community.smartsheet.com\/discussion\/96711\/sum-formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96711\/sum-formula-not-working","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CGM6H7VBPMYS\/capture-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T12:38:24+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":81308,"type":"question","name":"SmartSheet Tableau Web Connector","excerpt":"Can anybody please share the tech document for SmartSheet - Tableau Web Connector?","categoryID":320,"dateInserted":"2021-07-19T12:30:11+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T04:43:58+00:00","insertUserID":138112,"insertUser":{"userID":138112,"name":"Sazid","url":"https:\/\/community.smartsheet.com\/profile\/Sazid","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-07-19T12:28:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153975,"lastUser":{"userID":153975,"name":"Hai Dao Le","url":"https:\/\/community.smartsheet.com\/profile\/Hai%20Dao%20Le","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T04:37:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":93,"score":null,"hot":3293026449,"url":"https:\/\/community.smartsheet.com\/discussion\/81308\/smartsheet-tableau-web-connector","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/81308\/smartsheet-tableau-web-connector","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-07-20T08:40:31+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","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":56896,"type":"discussion","name":"Multiple Update Requests In One Email","excerpt":"Greetings - I currently have employees getting multiple update requests in one email. Please see the attached screenshot for an example. I am needing these to come thru as individual emails and not multiple update requests grouped into one email. Am I missing something in the settings? Hoping someone can help me sort this…","categoryID":321,"dateInserted":"2019-09-03T11:47:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-10-21T03:18:09+00:00","insertUserID":97791,"insertUser":{"userID":97791,"name":"Jack C","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-12-02T12:45:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":127877,"lastUser":{"userID":127877,"name":"Marco Moura","url":"https:\/\/community.smartsheet.com\/profile\/Marco%20Moura","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Xg9f39aOFno!8wjft6qx_yQ!RRDy54y-SyT","dateLastActive":"2022-10-21T07:05:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":929,"score":null,"hot":3233840738,"url":"https:\/\/community.smartsheet.com\/discussion\/56896\/multiple-update-requests-in-one-email","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56896\/multiple-update-requests-in-one-email","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/22\/fc\/22fc98d84ecafbc6f42274362cfde5f0.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"multiple update request - 1 email.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":206,"urlcode":"Update Requests","name":"Update Requests"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"}],"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":96821,"type":"question","name":"API smartsheet","excerpt":"hello here I want to ask about the smartsheet API, why here I try to pust always note found, even though the sample data I quoted from the smartsheet document, the url I tried is 'https:\/\/api.smartsheet.com\/2.0\/users\/{userId }\/alternateemails' here I want to ask uju if the userId is the user to enter the smartsheet Thank…","categoryID":321,"dateInserted":"2022-10-20T07:21:06+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T02:35:11+00:00","insertUserID":151723,"insertUser":{"userID":151723,"name":"jhon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jhon","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZPm1GQUgZjg!ZWm02cU4ajg!7k2ztc-A6P9","dateLastActive":"2022-10-21T02:32:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151723,"lastUser":{"userID":151723,"name":"jhon","title":"","url":"https:\/\/community.smartsheet.com\/profile\/jhon","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZPm1GQUgZjg!ZWm02cU4ajg!7k2ztc-A6P9","dateLastActive":"2022-10-21T02:32:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3332571377,"url":"https:\/\/community.smartsheet.com\/discussion\/96821\/api-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96821\/api-smartsheet","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/W8AQ3FD5MEE6\/screen-shot-2022-10-20-at-14-20-18.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-10-20 at 14.20.18.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-20T13:42:25+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":96639,"type":"question","name":"Creating a formula to track number of days but with a catch","excerpt":"So I have been tasked with creating a formula that tracks the number of days an element is \"No\". However, there are multiple forms submitted each day so I do not want to count the number of times a \"No\" is selected. It needs to be a formula that counts the consecutive days but then resets to 0 if the element has a \"Yes\"…","categoryID":322,"dateInserted":"2022-10-16T14:55:13+00:00","dateUpdated":"2022-10-17T08:11:51+00:00","dateLastComment":"2022-10-21T02:04:33+00:00","insertUserID":152523,"insertUser":{"userID":152523,"name":"CRUSJ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CRUSJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T01:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":152523,"lastUser":{"userID":152523,"name":"CRUSJ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/CRUSJ","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T01:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3332251186,"url":"https:\/\/community.smartsheet.com\/discussion\/96639\/creating-a-formula-to-track-number-of-days-but-with-a-catch","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96639\/creating-a-formula-to-track-number-of-days-but-with-a-catch","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LSJY3WASUDC2\/smartsheet-forum-7.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet forum 7.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-17T13:42:36+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}">

类别

受欢迎的标签

本周的领导人