Government

=DATE(2018, 4, 1)) Next I'd like to add…","categoryID":322,"dateInserted":"2018-07-24T17:24:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-06-29T11:02:55+00:00","insertUserID":55506,"insertUser":{"userID":55506,"name":"jjimenez55506","url":"https:\/\/community.smartsheet.com\/profile\/jjimenez55506","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-24T17:09:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":62,"countViews":8439,"score":null,"hot":3220526832,"url":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29166\/countifs-between-dates-criteria","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/libraries\/smiley\/images\/regular_smile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smiley"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":104851,"type":"question","name":"Form Options - Automation","excerpt":"Good morning, I'm trying to create a form in for entering and\/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…","categoryID":322,"dateInserted":"2023-05-04T17:03:54+00:00","dateUpdated":"2023-05-04T17:48:09+00:00","dateLastComment":"2023-05-04T17:34:51+00:00","insertUserID":7105,"insertUser":{"userID":7105,"name":"Laurie Bearden","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20Bearden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/001\/nT12MT79U1BCE.jpg","dateLastActive":"2023-05-04T17:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":7105,"lastUserID":7105,"lastUser":{"userID":7105,"name":"Laurie Bearden","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20Bearden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/001\/nT12MT79U1BCE.jpg","dateLastActive":"2023-05-04T17:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3366442725,"url":"https:\/\/community.smartsheet.com\/discussion\/104851\/form-options-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104851\/form-options-automation","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-04T17:30:28+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":204,"urlcode":"forms","name":"Forms"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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":39821,"type":"question","name":"Using nested MATCH\/INDEX across multiple columns","excerpt":"Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who receives cards. I want the master list to check off each card given out after it is logged into the tracker, however each…","categoryID":322,"dateInserted":"2019-01-25T11:21:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-05-03T12:35:44+00:00","insertUserID":65306,"insertUser":{"userID":65306,"name":"Joshua Peacock","url":"https:\/\/community.smartsheet.com\/profile\/Joshua%20Peacock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-02T09:48:33+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":847,"score":null,"hot":3231538607,"url":"https:\/\/community.smartsheet.com\/discussion\/39821\/using-nested-match-index-across-multiple-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39821\/using-nested-match-index-across-multiple-columns","format":"Html","groupID":null,"statusID":2,"image":{"url":"https:\/\/snag.gy\/QiyPjY.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Resources Issued"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-02T19:38: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":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":103670,"type":"question","name":"Is it possible to create a workflow to transfer indented rows to a separate sheet?","excerpt":"Is there any way for the workflow to trigger and move the indented row independently from their parent row to a separate mirrored sheet (exact same set up)? My specific scenario: Tracking form numbers that fall under different categories (series\/subseries). The forms are indented to be nested under their respective series…","categoryID":322,"dateInserted":"2023-04-05T20:15:07+00:00","dateUpdated":null,"dateLastComment":"2023-04-07T16:42:03+00:00","insertUserID":153204,"insertUser":{"userID":153204,"name":"LTKT","url":"https:\/\/community.smartsheet.com\/profile\/LTKT","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxY_qJUjoxKT8uMeTO2ISevBe2Zq2ser0s0O2eA7=s96-c","dateLastActive":"2023-04-12T15:05:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":153204,"lastUser":{"userID":153204,"name":"LTKT","url":"https:\/\/community.smartsheet.com\/profile\/LTKT","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxY_qJUjoxKT8uMeTO2ISevBe2Zq2ser0s0O2eA7=s96-c","dateLastActive":"2023-04-12T15:05:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":59,"score":null,"hot":3361612630,"url":"https:\/\/community.smartsheet.com\/discussion\/103670\/is-it-possible-to-create-a-workflow-to-transfer-indented-rows-to-a-separate-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103670\/is-it-possible-to-create-a-workflow-to-transfer-indented-rows-to-a-separate-sheet","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/UD3TYY9YBQAR\/active-forms-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Active Forms.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-06T15:20:12+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":263,"urlcode":"government","name":"Government"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"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":51991,"type":"discussion","name":"Counting number of times Name appears in multiple contact column","excerpt":"I have a column set up as a multiple contact to capture all authors on a journal publication. I would like to use a formula that will count the total number of times a specific name appears in then column. I have tried =COUNTIF({ALL AUTHORS},\"John Doe\"), but I know it does not yield all of the times the name appears. I…","categoryID":322,"dateInserted":"2019-07-01T14:48:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-04-06T14:28:47+00:00","insertUserID":59876,"insertUser":{"userID":59876,"name":"E_Pieper","url":"https:\/\/community.smartsheet.com\/profile\/E_Pieper","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-01T14:40:45+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":1433,"score":null,"hot":3242791015,"url":"https:\/\/community.smartsheet.com\/discussion\/51991\/counting-number-of-times-name-appears-in-multiple-contact-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/51991\/counting-number-of-times-name-appears-in-multiple-contact-column","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"}],"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":53381,"type":"discussion","name":"Extract Cell History For Formulas","excerpt":"Hello, Is there any way to extract the Cell history to calculate formulas. What I am trying to do is create metrics off the dates in the cell history. I.E. if a Dropdown list column starts on July 1 with Value 1 and changes to Value 2 on December 10th then Value 3 on December 21st. I want to measure and tract the time…","categoryID":322,"dateInserted":"2019-07-19T03:09:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-04-04T18:46:41+00:00","insertUserID":27881,"insertUser":{"userID":27881,"name":"bhope51","url":"https:\/\/community.smartsheet.com\/profile\/bhope51","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-04T18:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":27881,"lastUser":{"userID":27881,"name":"bhope51","url":"https:\/\/community.smartsheet.com\/profile\/bhope51","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-04T18:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":2497,"score":null,"hot":3244144596,"url":"https:\/\/community.smartsheet.com\/discussion\/53381\/extract-cell-history-for-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53381\/extract-cell-history-for-formulas","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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}">