添加插件和集成

=IF(AND([% Complete]@row = \"1\", OR([RA Status]@row = \"A\", [RA Status]@row = \"B\")), true)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":105523,"type":"question","name":"How to Add an absolute reference AND have a column formula without cross sheet references","excerpt":"Hi Starting at \"Part 1 Calc column Formulae are =DATE([Year of next Event Adjusted for New Year]1, [Month of Next Event Adjusted if >12]1, 1) =(NETDAYS([Reference date of a Monday (Used for Calc 2)]@row, [First Day of \"Month of Next Event\" Part 1 of calc]@row) - (7 * INT(NETDAYS([Reference date of a Monday (Used for Calc…","categoryID":321,"dateInserted":"2023-05-22T08:55:50+00:00","dateUpdated":null,"dateLastComment":"2023-05-22T09:26:10+00:00","insertUserID":152702,"insertUser":{"userID":152702,"name":"Andrew McCrae","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20McCrae","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-22T10:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-22T22:34:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3369495120,"url":"https:\/\/community.smartsheet.com\/discussion\/105523\/how-to-add-an-absolute-reference-and-have-a-column-formula-without-cross-sheet-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105523\/how-to-add-an-absolute-reference-and-have-a-column-formula-without-cross-sheet-references","format":"Rich","lastPost":{"discussionID":105523,"commentID":376895,"name":"Re: How to Add an absolute reference AND have a column formula without cross sheet references","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376895#Comment_376895","dateInserted":"2023-05-22T09:26:10+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-22T22:34:05+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":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1Z6C2T1T0S4D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-22T10:09:18+00:00","dateAnswered":"2023-05-22T09:05:55+00:00","acceptedAnswers":[{"commentID":376892,"body":"

Got it to work. Sometimes in formulating a question, you are forced to think. I changed the formula to eliminate the reference by putting a fixed date like follows. I am sure I could make it more elegant but it is working for me it appears.<\/p>

=(NETDAYS(DATE(1900, 1, 1), [First Day of \"Month of Next Event\" Part 1 of calc]@row) - (7 * INT(NETDAYS(DATE(1900, 1, 1), [First Day of \"Month of Next Event\" Part 1 of calc]@row) \/ 7)) + 1)<\/p>"},{"commentID":376895,"body":"

Hi @Andrew McCrae<\/a> <\/p>

I hope you're well and safe!<\/p>

Excellent! Glad you got it working!<\/p>

Be safe, and have a fantastic day!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Please support the Community by marking your post<\/em> <\/em><\/strong>with <\/em>the accepted answer\/helpful<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":105444,"type":"question","name":"Moving Report Filter Groups","excerpt":"I can't figure out how to move an entire filter group in a report. I can move a condition into and out of a group but not move the whole group.","categoryID":321,"dateInserted":"2023-05-18T19:51:43+00:00","dateUpdated":"2023-05-19T08:33:50+00:00","dateLastComment":"2023-05-22T16:25:51+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-05-22T16:24:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":160816,"lastUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-05-22T16:24:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":33,"score":null,"hot":3369214654,"url":"https:\/\/community.smartsheet.com\/discussion\/105444\/moving-report-filter-groups","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105444\/moving-report-filter-groups","format":"Rich","tagIDs":[265],"lastPost":{"discussionID":105444,"commentID":376952,"name":"Re: Moving Report Filter Groups","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376952#Comment_376952","dateInserted":"2023-05-22T16:25:51+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-05-22T16:24:18+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":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-22T16:24:52+00:00","dateAnswered":"2023-05-22T11:53:00+00:00","acceptedAnswers":[{"commentID":376900,"body":"

Hi @Sara H<\/a> <\/p>

With filters the order does not matter for priority as you're either filtering or not filtering out rows. For example, if you filter out all rows that say \"Value 1\" and<\/em> \"Value 2\" then no matter what order you put those in, both Value 1 and 2 will be filtered out. (That said, the Sort<\/strong> order in a Report does look at location for priority, you're correct!)<\/p>

What organizes a Filter <\/strong>setting will be the AND or OR statements that you see on the right in terms of grouping the different filter statements together, does that make sense? <\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":265,"urlcode":"Reports","name":"Reports"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">