公式

=7, YEAR(TODAY())&\"-\"&(YEAR(TODAY())+1), (YEAR(TODAY())-1)&\"-\"&YEAR(TODAY()))","categoryID":322,"dateInserted":"2023-06-02T19:06:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T19:46:15+00:00","insertUserID":161705,"insertUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161705,"lastUser":{"userID":161705,"name":"Christina S.","url":"https:\/\/community.smartsheet.com\/profile\/Christina%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T18:07:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":71,"score":null,"hot":3371469191,"url":"https:\/\/community.smartsheet.com\/discussion\/105974\/help-creating-a-formula-that-generates-the-current-fiscal-year","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105974\/help-creating-a-formula-that-generates-the-current-fiscal-year","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T19:45:43+00:00","dateAnswered":"2023-06-02T19:21: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":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":105965,"type":"question","name":"How to Join values from a reference sheet based on selections in a multi-select dropdown","excerpt":"Based on preliminary searching, it seems this may be impossible, but I am hoping to use values chosen from a multi-select dropdown to collect and join values associated with each dropdown in a single cell. In this example, a donation manager is choosing donation items from a dropdown with over 40 selections. In the column…","categoryID":322,"dateInserted":"2023-06-02T16:46:33+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T19:20:42+00:00","insertUserID":150707,"insertUser":{"userID":150707,"name":"KT_H","url":"https:\/\/community.smartsheet.com\/profile\/KT_H","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7r65MnQG4KHfpM6sDg02QZH9cQedVQiNKhYciZ=s96-c","dateLastActive":"2023-06-05T21:15:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":48,"score":null,"hot":3371461035,"url":"https:\/\/community.smartsheet.com\/discussion\/105965\/how-to-join-values-from-a-reference-sheet-based-on-selections-in-a-multi-select-dropdown","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105965\/how-to-join-values-from-a-reference-sheet-based-on-selections-in-a-multi-select-dropdown","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/33HIKVOQ5E8P\/screen-shot-2023-06-02-at-9-37-17-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2023-06-02 at 9.37.17 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T18:57:49+00:00","dateAnswered":"2023-06-02T18:37:57+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":105970,"type":"question","name":"Trying to evaluate multiple columns with an IF statement","excerpt":"I keep getting a syntax error for some reason but can't figure out why. I am basically trying to set a status icon of 'Sunny\" if the status of the risk is \"closed\" and if not closed, i am using the other icons based on the level of the risk. here is the formula: =IF([Status]@row = “Closed”, “sunny”, IF([Risk Score]@row <=…","categoryID":322,"dateInserted":"2023-06-02T17:58:00+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T19:19:11+00:00","insertUserID":162035,"insertUser":{"userID":162035,"name":"Drew N.","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/Drew%20N.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T12:14:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":63,"score":null,"hot":3371464031,"url":"https:\/\/community.smartsheet.com\/discussion\/105970\/trying-to-evaluate-multiple-columns-with-an-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105970\/trying-to-evaluate-multiple-columns-with-an-if-statement","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T18:44:44+00:00","dateAnswered":"2023-06-02T18:24:38+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":105897,"type":"question","name":"Find Number of Duplicates within Multiple Columns","excerpt":"I need to create a COUNTIF formula (I assume) that will count the number of duplicates of a number in at least 10 different columns. I will eventually create a notification for the end result but I can't figure out how to do it over more than one column without only being able to compare the other columns to just one…","categoryID":322,"dateInserted":"2023-06-01T15:38:11+00:00","dateUpdated":"2023-06-01T15:39:02+00:00","dateLastComment":"2023-06-02T18:19:05+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-06-23T17:40:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":160816,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-23T19:11:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":101,"score":null,"hot":3371369836,"url":"https:\/\/community.smartsheet.com\/discussion\/105897\/find-number-of-duplicates-within-multiple-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105897\/find-number-of-duplicates-within-multiple-columns","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/38V5RD9W1V8E\/smartsheet-help.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Help.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T18:32:41+00:00","dateAnswered":"2023-06-02T18:19:05+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":105963,"type":"question","name":"Pasting formulas from a plain text document causing #Unparseable Error","excerpt":"Hello all, I am building a complex multilingual sheet that will be creating various documents using Document Builder depending on the user's choice of country and language. There are a lot of column formulas that are very similar but use different languages. I am using a text editor to track the formulas but have found I…","categoryID":322,"dateInserted":"2023-06-02T16:29:50+00:00","dateUpdated":"2023-06-02T16:30:20+00:00","dateLastComment":"2023-06-02T16:57:16+00:00","insertUserID":143028,"insertUser":{"userID":143028,"name":"H Brian","title":"","url":"https:\/\/community.smartsheet.com\/profile\/H%20Brian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nSKJ2BAYVP7XH.png","dateLastActive":"2023-06-21T15:24:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":143028,"lastUserID":143028,"lastUser":{"userID":143028,"name":"H Brian","title":"","url":"https:\/\/community.smartsheet.com\/profile\/H%20Brian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nSKJ2BAYVP7XH.png","dateLastActive":"2023-06-21T15:24:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":28,"score":null,"hot":3371450226,"url":"https:\/\/community.smartsheet.com\/discussion\/105963\/pasting-formulas-from-a-plain-text-document-causing-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105963\/pasting-formulas-from-a-plain-text-document-causing-unparseable-error","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-02T16:40: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":[{"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":105954,"type":"question","name":"Sheet Reference Formula Unparseable Error","excerpt":"I'm using the following formula, which references another sheet to pull in definitions\/text: =IF([Job Family Recommendation]@row = \"Accounting Operations\", {Job Family Definitions Range 5}), IF([Job Family Recommendation]@row = \"Billing\", {Job Family Definitions Range 2}) The first leg of the formula works, but when I add…","categoryID":322,"dateInserted":"2023-06-02T14:53:36+00:00","dateUpdated":"2023-06-02T14:58:35+00:00","dateLastComment":"2023-06-02T16:45:57+00:00","insertUserID":146191,"insertUser":{"userID":146191,"name":"Tony Fronza","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Fronza","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xG908UE9JXI!c4C1Jy0cw2Q!tPis-mqrwhr","dateLastActive":"2023-06-22T19:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":146191,"lastUser":{"userID":146191,"name":"Tony Fronza","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Fronza","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xG908UE9JXI!c4C1Jy0cw2Q!tPis-mqrwhr","dateLastActive":"2023-06-22T19:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":51,"score":null,"hot":3371443173,"url":"https:\/\/community.smartsheet.com\/discussion\/105954\/sheet-reference-formula-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105954\/sheet-reference-formula-unparseable-error","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T16:46:09+00:00","dateAnswered":"2023-06-02T14:55:47+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":105949,"type":"question","name":"Help with Unparseable If(And) formula","excerpt":"Please help with reviewing the formula below. I am getting #UNPARSEABLE. =IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),\"Y\", \"N\") If I only do the single IF, it returns the value correctly : =IF([Spend 2022]@row = 0, \"Y\", \"N\") [Spend 2022] and [Spend 2023] columns are text…","categoryID":322,"dateInserted":"2023-06-02T12:50:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T15:52:22+00:00","insertUserID":138764,"insertUser":{"userID":138764,"name":"RScapperotti","url":"https:\/\/community.smartsheet.com\/profile\/RScapperotti","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T16:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":140393,"lastUser":{"userID":140393,"name":"JMcI","url":"https:\/\/community.smartsheet.com\/profile\/JMcI","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BOFXQWc65no!ui_XJ_tgm3w!7Rw_Zdwdgmo","dateLastActive":"2023-06-02T16:06:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":60,"score":null,"hot":3371433745,"url":"https:\/\/community.smartsheet.com\/discussion\/105949\/help-with-unparseable-if-and-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105949\/help-with-unparseable-if-and-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T14:43:57+00:00","dateAnswered":"2023-06-02T13:30:09+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":105953,"type":"question","name":"How do you limit items in a dropdown menu field based on the selection of another?","excerpt":"We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…","categoryID":322,"dateInserted":"2023-06-02T14:42:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T14:50:51+00:00","insertUserID":146191,"insertUser":{"userID":146191,"name":"Tony Fronza","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Fronza","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xG908UE9JXI!c4C1Jy0cw2Q!tPis-mqrwhr","dateLastActive":"2023-06-22T19:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":146191,"lastUser":{"userID":146191,"name":"Tony Fronza","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Fronza","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xG908UE9JXI!c4C1Jy0cw2Q!tPis-mqrwhr","dateLastActive":"2023-06-22T19:25:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":45,"score":null,"hot":3371435591,"url":"https:\/\/community.smartsheet.com\/discussion\/105953\/how-do-you-limit-items-in-a-dropdown-menu-field-based-on-the-selection-of-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105953\/how-do-you-limit-items-in-a-dropdown-menu-field-based-on-the-selection-of-another","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-02T14:46:04+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":426,"urlcode":"DataTable","name":"DataTable"},{"tagID":497,"urlcode":"column-types","name":"Column Types"}],"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":77827,"type":"discussion","name":"Work Breakdown Structure (WBS) - Column Formula Configuration","excerpt":"Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in case some may find it helpful in executing project management solutions, this…","categoryID":338,"dateInserted":"2021-03-30T17:12:03+00:00","dateUpdated":"2023-06-02T15:51:11+00:00","dateLastComment":"2023-06-02T14:45:51+00:00","insertUserID":1253,"insertUser":{"userID":1253,"name":"Tom Zylstra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tom%20Zylstra","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xClDcfK76Do!pP9C6dL_ofo!59RVlYUSqAK","dateLastActive":"2022-08-25T19:58:25+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":91566,"lastUserID":161824,"lastUser":{"userID":161824,"name":"Sandra Wlasiewicz","url":"https:\/\/community.smartsheet.com\/profile\/Sandra%20Wlasiewicz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T12:02:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":47,"countViews":7285,"score":23,"hot":3302876574,"url":"https:\/\/community.smartsheet.com\/discussion\/77827\/work-breakdown-structure-wbs-column-formula-configuration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/77827\/work-breakdown-structure-wbs-column-formula-configuration","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9SMK88AK3HG8\/cleanshot-2021-03-30-at-10-25-59.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CleanShot 2021-03-30 at 10.25.59.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":338,"name":"Best Practice","url":"https:\/\/community.smartsheet.com\/categories\/best-practices","allowedDiscussionTypes":["discussion","poll","question"]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":105903,"type":"question","name":"CountIF Formula for Dates in the Past","excerpt":"I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula: =COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project. I want to change this to…","categoryID":322,"dateInserted":"2023-06-01T16:19:48+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T13:24:28+00:00","insertUserID":147103,"insertUser":{"userID":147103,"name":"MirandaLang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MirandaLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ITFJ24KMOI0L\/n2LSG2D9UKW72.jpeg","dateLastActive":"2023-06-20T17:25:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":147103,"lastUser":{"userID":147103,"name":"MirandaLang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/MirandaLang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ITFJ24KMOI0L\/n2LSG2D9UKW72.jpeg","dateLastActive":"2023-06-20T17:25:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":66,"score":null,"hot":3371349856,"url":"https:\/\/community.smartsheet.com\/discussion\/105903\/countif-formula-for-dates-in-the-past","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105903\/countif-formula-for-dates-in-the-past","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T13:24:06+00:00","dateAnswered":"2023-06-01T16:54: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":[{"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}">