功能

=TODAY(-7)) I'm not sure what's going wrong or where to insert the formula in the sheet (will any cell do?). Thanks, Emily","categoryID":322,"dateInserted":"2019-12-17T22:21:37+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T22:32:33+00:00","insertUserID":114024,"insertUser":{"userID":114024,"name":"Emily Alpert","url":"https:\/\/community.smartsheet.com\/profile\/Emily%20Alpert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-12-18T19:48:51+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-06-13T20:32:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":218,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64826\/how-to-create-formula-to-count-over-the-past-seven-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64826\/how-to-create-formula-to-count-over-the-past-seven-days","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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":61986,"type":"question","name":"Sum all Rows","excerpt":"My sheet has 3 columns (Team, Activity, Amount). I have a summary section at the top of my sheet where I want to use a SUMIF function to total up the amount for each Team. Generally, I can get the SUMIF function to work just fine. But, I run into an issue when adding new rows. The function looks like this:…","categoryID":322,"dateInserted":"2019-11-04T18:59:52+00:00","dateUpdated":"2019-12-15T03:54:39+00:00","dateLastComment":"2019-12-17T21:30:56+00:00","insertUserID":7585,"insertUser":{"userID":7585,"name":"Ramsay Zaki","url":"https:\/\/community.smartsheet.com\/profile\/Ramsay%20Zaki","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-03T22:48:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":6388,"lastUserID":32451,"lastUser":{"userID":32451,"name":"Jim Schaffhausen","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Schaffhausen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/ab\/64\/nab64ad25a69c4c87f61191e3d6dcb601.JPG","dateLastActive":"2023-01-30T14:17:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1009,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/61986\/sum-all-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61986\/sum-all-rows","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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":64813,"type":"question","name":"Sheet Summary","excerpt":"Hi, When copying a sheet summary to other sheets within the same workspace, it carries the field names but not always the information within the field. For example, after having copied the sheet Summary, the \"Completion %\" shows =[% Complete]30 + \" %\" or #UNPARSEABLE, instead of an actual number, ie. 50 %. There's no…","categoryID":321,"dateInserted":"2019-12-17T16:28:07+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T18:21:37+00:00","insertUserID":112046,"insertUser":{"userID":112046,"name":"Razetto","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Razetto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-13T20:14:28+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-06-13T20:32:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":128,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/64813\/sheet-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64813\/sheet-summary","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/570\/IA9GH371P0O0.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2019-12-17 111728.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":64799,"type":"question","name":"IF formula with multiple criteria","excerpt":"I am attempting to write a formula based on 2 separate criteria, though I feel like I need some type of \"BUT\" statement and could use some help. I want a picklist column to read YES or NO depending on the following: IF Ins Status = Current OR N\/A AND Agreement EXE is checked THEN Approved for Work = YES, BUT, IF Agreement…","categoryID":322,"dateInserted":"2019-12-16T22:24:45+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T17:06:06+00:00","insertUserID":103041,"insertUser":{"userID":103041,"name":"Natalia Kataoka","url":"https:\/\/community.smartsheet.com\/profile\/Natalia%20Kataoka","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HHlD32Ebgjo!3-jCv-0k_iQ!r0sqH0qPD_v","dateLastActive":"2023-05-12T14:45:56+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-13T19:40:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":353,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/64799\/if-formula-with-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64799\/if-formula-with-multiple-criteria","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/815\/GGB2YTB63OP9.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Approved for work screenshot.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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":64811,"type":"question","name":"Does the link for a form change if the sheet is moved?","excerpt":"I am an admin working on cleaning up our structure within Smartsheet to utilize workspaces and folders more. Will the link for a form that is shared across many users change if I move the sheet to a workspace?","categoryID":321,"dateInserted":"2019-12-17T15:44:16+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T15:53:09+00:00","insertUserID":113986,"insertUser":{"userID":113986,"name":"Bethann Whitman","url":"https:\/\/community.smartsheet.com\/profile\/Bethann%20Whitman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-29T15:31:12+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-06-13T20:32:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":498,"score":1,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/64811\/does-the-link-for-a-form-change-if-the-sheet-is-moved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64811\/does-the-link-for-a-form-change-if-the-sheet-is-moved","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2019-12-17T15:51:03+00:00","dateAnswered":"2019-12-17T15:49:08+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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":64796,"type":"question","name":"Formula for percentage complete and duration remaining","excerpt":"I am trying to develop a formula to flag tasks that are less than 50% complete but more than 50% of the duration has passed. I'm not sure if my math is correct. But aside from that, can Smartsheet perform functions like the one I am proposing below? Currently, it returns an unparseable error. If I get this formula to work,…","categoryID":322,"dateInserted":"2019-12-16T20:27:04+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T15:16:57+00:00","insertUserID":109121,"insertUser":{"userID":109121,"name":"Jamila","url":"https:\/\/community.smartsheet.com\/profile\/Jamila","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hLtUYWHM7_Q!3YvWPz3Clb4!KLo10CHIh7K","dateLastActive":"2023-02-04T09:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":109121,"lastUser":{"userID":109121,"name":"Jamila","url":"https:\/\/community.smartsheet.com\/profile\/Jamila","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!hLtUYWHM7_Q!3YvWPz3Clb4!KLo10CHIh7K","dateLastActive":"2023-02-04T09:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":1216,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/64796\/formula-for-percentage-complete-and-duration-remaining","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64796\/formula-for-percentage-complete-and-duration-remaining","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2019-12-17T15:17:03+00:00","dateAnswered":"2019-12-16T20:43:00+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":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":64805,"type":"question","name":"Deleted user still able to access Smartsheet","excerpt":"Hi, I'm looking for some help on how to eliminate some risk when team members leave the company. They are deleted as a user and sheets transferred, however these said users after they have been deleted are still able to access into Smartsheet when they log on with a password but not single sign on. Once logged on they…","categoryID":321,"dateInserted":"2019-12-17T04:10:58+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T08:04:32+00:00","insertUserID":113952,"insertUser":{"userID":113952,"name":"Jorjie Higginson","url":"https:\/\/community.smartsheet.com\/profile\/Jorjie%20Higginson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xBVUsQNVJ4Q!-vDXN8tgGJQ!MjHwEP6g7zU","dateLastActive":"2020-03-05T22:13:31+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-06-13T20:32:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":333,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64805\/deleted-user-still-able-to-access-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64805\/deleted-user-still-able-to-access-smartsheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":64806,"type":"question","name":"How to view a calendar by column other than the primary","excerpt":"Hello Smartsheet Community, I am trying to find a work around to view a calendar by more than just the info in the primary column. I currently have a sheet that contains all of our workshop orders for a particular product range. It contains the customer name, product type, dispatch date, ect. We look at this sheet in…","categoryID":321,"dateInserted":"2019-12-17T05:47:02+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T07:51:28+00:00","insertUserID":61206,"insertUser":{"userID":61206,"name":"Mitch@Enmach","url":"https:\/\/community.smartsheet.com\/profile\/Mitch%40Enmach","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-17T01:03:03+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-06-13T20:32:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":531,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64806\/how-to-view-a-calendar-by-column-other-than-the-primary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64806\/how-to-view-a-calendar-by-column-other-than-the-primary","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":64797,"type":"question","name":"Count only if Parent","excerpt":"I have a [RowID] column that is populated by this formula =IF(ANCESTORS@row = 0, COUNT($ANCESTORS$1:$ANCESTORS@row, \"\")) It returns sequential numbers but, I need it to only count if Ancestor = 0 Secondly, I need the result fill format to look like this 0000 (like an auto number) 0001 0002... 0100 0101 0102.. 1000","categoryID":322,"dateInserted":"2019-12-16T20:28:19+00:00","dateUpdated":null,"dateLastComment":"2019-12-17T02:37:00+00:00","insertUserID":104631,"insertUser":{"userID":104631,"name":"Detrie Zacharias","url":"https:\/\/community.smartsheet.com\/profile\/Detrie%20Zacharias","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nQtXn4Wtj_o!wSnUcJnZ0Dw!lFH98PKZDWF","dateLastActive":"2023-01-27T16:30:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":104631,"lastUser":{"userID":104631,"name":"Detrie Zacharias","url":"https:\/\/community.smartsheet.com\/profile\/Detrie%20Zacharias","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nQtXn4Wtj_o!wSnUcJnZ0Dw!lFH98PKZDWF","dateLastActive":"2023-01-27T16:30:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":454,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/64797\/count-only-if-parent","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64797\/count-only-if-parent","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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"}],"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}">