值得探索的领域
You would need to set up Automations to change the cell value so that static data is in there as opposed to a dynamic formula.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-15 23:25:53","updateUser":{"userID":137906,"name":"Vinton Douglas","url":"https:\/\/community.smartsheet.com\/profile\/Vinton%20Douglas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-15T23:24:35+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":73955,"type":"question","name":"Project Health Formula Help!","excerpt":"I am trying to add a column to my project plan to track the health of the lines in my plan based on the details in the % complete and due date columns. I would like to use the red, yellow and green symbols in the formula. Are there any formula's that you can recommend for tracking project health? I think the formula I am…","categoryID":322,"dateInserted":"2020-12-11T19:26:45+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T23:17:44+00:00","insertUserID":129716,"insertUser":{"userID":129716,"name":"Danielle Bell","url":"https:\/\/community.smartsheet.com\/profile\/Danielle%20Bell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-03-30T15:39:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-09-15T20:05:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":505,"score":null,"hot":3271005869,"url":"https:\/\/community.smartsheet.com\/discussion\/73955\/project-health-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/73955\/project-health-formula-help","format":"Rich","lastPost":{"discussionID":73955,"commentID":343723,"name":"Re: Project Health Formula Help!","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/343723#Comment_343723","dateInserted":"2022-09-15T23:17:44+00:00","insertUserID":11072,"insertUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-09-15T20:05:49+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":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-12-11T19:42:15+00:00","dateAnswered":"2020-12-11T19:39:56+00:00","acceptedAnswers":[{"commentID":271641,"body":"
Did that work for you?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","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":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"label":"Newest Questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":5,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"]},"discussions":[{"discussionID":95422,"type":"question","name":"can updates to line items include photos?","excerpt":"I have an audit that is conducted and I'm trying to figure a way to automatically send follow up requests to ensure the item is addressed. Based on a closure date, can I send some \"form\" or something that asks them to provide closure notes, date it was closed and photo evidence? Not really sure if this can be done. I know…","categoryID":321,"dateInserted":"2022-09-15T23:09:39+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T23:49:53+00:00","insertUserID":127000,"insertUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":127000,"lastUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":9,"score":null,"hot":3326570372,"url":"https:\/\/community.smartsheet.com\/discussion\/95422\/can-updates-to-line-items-include-photos","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95422\/can-updates-to-line-items-include-photos","format":"Rich","lastPost":{"discussionID":95422,"commentID":343729,"name":"Re: can updates to line items include photos?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/343729#Comment_343729","dateInserted":"2022-09-15T23:49:53+00:00","insertUserID":127000,"insertUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-15T23:41:06+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-15 23:41:07","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-09-16T00:06:31+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":[]},{"discussionID":95421,"type":"question","name":"create a due date based on report date and category","excerpt":"looking for a formula to do the following: Target due date based on category: Due date is report date, status is OPEN +number of days based on risk category High - report date +1 day Medium - report date +3 days Low - report date + 7 days Advisor - report date + 10 days then place the target due date in the column TYIA","categoryID":322,"dateInserted":"2022-09-15T23:06:16+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T23:06:16+00:00","insertUserID":127000,"insertUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":127000,"lastUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+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\/95421\/create-a-due-date-based-on-report-date-and-category","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95421\/create-a-due-date-based-on-report-date-and-category","format":"Rich","lastPost":{"discussionID":95421,"name":"create a due date based on report date and category","url":"https:\/\/community.smartsheet.com\/discussion\/95421\/create-a-due-date-based-on-report-date-and-category","dateInserted":"2022-09-15T23:06:16+00:00","insertUserID":127000,"insertUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+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,"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":[]},{"discussionID":95420,"type":"question","name":"Once due date is met, start new row based on recurrence interval","excerpt":"I have some reports that are due at different intervals, 1 year, 5 years, etc. I want to create a formula (or method) that when the due date is reached it will set the next due date. It would actually be neat if the system would generate the next line, but I can live with just doing the formula. And need to due this if the…","categoryID":322,"dateInserted":"2022-09-15T22:59:26+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T23:55:38+00:00","insertUserID":127000,"insertUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":127000,"lastUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":9,"score":null,"hot":3326570104,"url":"https:\/\/community.smartsheet.com\/discussion\/95420\/once-due-date-is-met-start-new-row-based-on-recurrence-interval","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95420\/once-due-date-is-met-start-new-row-based-on-recurrence-interval","format":"Rich","lastPost":{"discussionID":95420,"commentID":343730,"name":"Re: Once due date is met, start new row based on recurrence interval","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/343730#Comment_343730","dateInserted":"2022-09-15T23:55:38+00:00","insertUserID":127000,"insertUser":{"userID":127000,"name":"Tammy Luther","url":"https:\/\/community.smartsheet.com\/profile\/Tammy%20Luther","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pgleqXaVtro!nqnQn5yhnD4!Zo2HSKC4cgz","dateLastActive":"2022-09-15T23:47:37+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-09-15T23:28:38+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-15 23:28:38","updateUser":{"userID":89971,"name":"MCorbin","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MCorbin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/80PUK21NFANO\/nKJOX5CKCTKS0.jpeg","dateLastActive":"2022-09-16T00:08:17+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"}}},"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":95419,"type":"question","name":"Stumped on a SUMIFS for Fiscal Year (FY)","excerpt":"Hello everyone, I am a bit stumped on a solution. I tend to not like to hardcode information into a formula. I was working through a solution to help manage a Business Development (BD) pipeline. With the help of the community, I figured out how to do a YTD. But then I was thinking that it didn't make sense to have the BD…","categoryID":322,"dateInserted":"2022-09-15T21:26:05+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T22:33:22+00:00","insertUserID":152373,"insertUser":{"userID":152373,"name":"Christopher Sullivan","url":"https:\/\/community.smartsheet.com\/profile\/Christopher%20Sullivan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-15T21:26:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":128386,"lastUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2022-09-16T00:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":9,"score":null,"hot":3326558967,"url":"https:\/\/community.smartsheet.com\/discussion\/95419\/stumped-on-a-sumifs-for-fiscal-year-fy","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95419\/stumped-on-a-sumifs-for-fiscal-year-fy","format":"Rich","tagIDs":[238,254],"lastPost":{"discussionID":95419,"commentID":343720,"name":"Re: Stumped on a SUMIFS for Fiscal Year (FY)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/343720#Comment_343720","dateInserted":"2022-09-15T22:33:22+00:00","insertUserID":128386,"insertUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2022-09-16T00:28:31+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-09-15T22:33:22+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-15 22:33:22","updateUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2022-09-16T00:28:31+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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":95418,"type":"question","name":"IF statement inside a COLLECT","excerpt":"Why do all of these formulas work: SUM(COLLECT({Value}, {Location}, Location@row)) SUM(COLLECT({Value}, {Location}, <>\"\")) SUM(COLLECT({Value}, {Location}, IF(index@row=1, \"Boston\", Location@row))) But this does not: SUM(COLLECT({Value}, {Location}, IF(index@row=1, <>\"\", Location@row))) I'm trying to understand this…","categoryID":322,"dateInserted":"2022-09-15T21:19:06+00:00","dateUpdated":null,"dateLastComment":"2022-09-15T21:19:06+00:00","insertUserID":128386,"insertUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2022-09-16T00:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":128386,"lastUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2022-09-16T00:28:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":14,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/95418\/if-statement-inside-a-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95418\/if-statement-inside-a-collect","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95418,"name":"IF statement inside a COLLECT","url":"https:\/\/community.smartsheet.com\/discussion\/95418\/if-statement-inside-a-collect","dateInserted":"2022-09-15T21:19:06+00:00","insertUserID":128386,"insertUser":{"userID":128386,"name":"SJ Sellers","url":"https:\/\/community.smartsheet.com\/profile\/SJ%20Sellers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2f9Wflccqfo!!HbwDxQuYr7v","dateLastActive":"2022-09-16T00:28:31+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,"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"}]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
探索。问。的答案。
找到与Smartsheet相关的所有点对点信息——从项目管理最佳实践到来自其他用户和Smartsheet专家的宝贵指导。
