Formulas and Functions

=TODAY (-7)) The parenthesis around the -7 are pink. The parenthesis after SUMIFS and at the end are blue. I've tried a few…","categoryID":322,"dateInserted":"2021-02-22T22:04:17+00:00","dateUpdated":"2021-02-22T22:33:48+00:00","dateLastComment":"2021-02-24T11:26:57+00:00","insertUserID":131616,"insertUser":{"userID":131616,"name":"Andrea Westrich","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Westrich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!06vS_zj5Rrw!!Vj-bj4lNhSM","dateLastActive":"2023-08-11T19:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":131616,"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-19T18:57:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":125,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76464\/sumifs-for-last-7-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76464\/sumifs-for-last-7-days","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-23T03:15:43+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":[],"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":72985,"type":"question","name":"Counting checkboxes in a column when using column formulas","excerpt":"Hello, Very happy with the column formula functionality, I used it in my sheets, like this: Check the checkbox in the Catalogues (column), IF Hosted Catalogue OR Punch Out L1 OR Punch Out L2 is checked. =IF(OR([Hosted Catalogue]@row = 1; [Punch Out L1]@row = 1; [Punch Out L2]@row = 1); 1; 0) --> convert into column…","categoryID":322,"dateInserted":"2020-11-09T19:24:47+00:00","dateUpdated":"2022-12-21T18:05:28+00:00","dateLastComment":"2021-02-24T10:49:43+00:00","insertUserID":89716,"insertUser":{"userID":89716,"name":"fkooman89716","url":"https:\/\/community.smartsheet.com\/profile\/fkooman89716","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-08\/7d\/ae\/n7dae6bb4ac062330925828ef64c03ab2.jpg","dateLastActive":"2022-10-19T06:02:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-19T18:57:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":355,"score":null,"hot":3219116670,"url":"https:\/\/community.smartsheet.com\/discussion\/72985\/counting-checkboxes-in-a-column-when-using-column-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/72985\/counting-checkboxes-in-a-column-when-using-column-formulas","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/9J1PH2IP5V7K\/screenshot-2020-11-09-at-20-12-39.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2020-11-09 at 20.12.39.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-11-13T07:25:32+00:00","dateAnswered":"2020-11-12T19:05: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":[],"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":76432,"type":"question","name":"Past Due Formula via Date Column in references source sheet","excerpt":"Hello, I have the below formula to show total count of projects that are less than or equal to today days and the due date. =COUNTIFS({Estimator}, [Assigned To]@row, {Assigned To}, [Assigned To]@row, {Quote Due Date}, <=TODAY(), {Quote Sent Date}, \"//www.santa-greenland.com/community/categories/formulas-and-functions/\") How can this be tweak to show, Total Count Projects Past Their Due Date?…","categoryID":322,"dateInserted":"2021-02-22T04:55:06+00:00","dateUpdated":null,"dateLastComment":"2021-02-24T10:39:23+00:00","insertUserID":126400,"insertUser":{"userID":126400,"name":"Ty Wickliffe","url":"https:\/\/community.smartsheet.com\/profile\/Ty%20Wickliffe","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hhjXoU20N5Y!xFNWcZWt6To!3JcaPKYQGb-","dateLastActive":"2021-02-23T04:26:10+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-19T18:57:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":114,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76432\/past-due-formula-via-date-column-in-references-source-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76432\/past-due-formula-via-date-column-in-references-source-sheet","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-23T00:25:11+00:00","dateAnswered":"2021-02-22T06:23: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":[],"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":75863,"type":"question","name":"How to use a COUNTIFS formula that excludes multiple criterion in Multi-Select Dropdown column?","excerpt":"I'm trying to count the total number of values in a Multi-Select Dropdown column when criteria in another Multi-Select Dropdown column is not present. For example, let's say I have a FRUIT column with Apple, Orange, Banana, and Kiwi values. I also have a STATUS column with Rotten, Fresh, Stolen, and Eaten values. In rows…","categoryID":322,"dateInserted":"2021-02-07T04:55:25+00:00","dateUpdated":null,"dateLastComment":"2021-02-24T04:28:00+00:00","insertUserID":107641,"insertUser":{"userID":107641,"name":"ALMF","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ALMF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n9SCK0BN9D6E5.png","dateLastActive":"2022-05-14T02:12:53+00:00","banned":0,"punished":0,"private":true,"label":"✭✭"},"updateUserID":null,"lastUserID":107641,"lastUser":{"userID":107641,"name":"ALMF","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ALMF","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n9SCK0BN9D6E5.png","dateLastActive":"2022-05-14T02:12:53+00:00","banned":0,"punished":0,"private":true,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":934,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/75863\/how-to-use-a-countifs-formula-that-excludes-multiple-criterion-in-multi-select-dropdown-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75863\/how-to-use-a-countifs-formula-that-excludes-multiple-criterion-in-multi-select-dropdown-column","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/6DRIW0OKXFNR\/screen-shot-2021-02-06-at-11-53-34-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2021-02-06 at 11.53.34 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-12T18:59:49+00:00","dateAnswered":"2021-02-07T11:55:23+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":76458,"type":"question","name":"Return a cell when one column matches another within an IF statement.","excerpt":"Morning, I've been struggling with how to return a specific value from two columns. We have created a risk register, and we want to show the overall risk rating for the project. The Overall risk is simply the risk of the highest ranked risk regardless of count. Initially, we are just using an IF statement, with a HAS on…","categoryID":322,"dateInserted":"2021-02-22T19:44:55+00:00","dateUpdated":null,"dateLastComment":"2021-02-24T01:27:21+00:00","insertUserID":125810,"insertUser":{"userID":125810,"name":"Nick Horton","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Horton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-08T19:58:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":125810,"lastUser":{"userID":125810,"name":"Nick Horton","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Horton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-08T19:58:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":112,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76458\/return-a-cell-when-one-column-matches-another-within-an-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76458\/return-a-cell-when-one-column-matches-another-within-an-if-statement","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-22T20:34:31+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":76522,"type":"question","name":"Sumif by year and month","excerpt":"i am trying to sum my values that are registered in a selected year and month without doing a start and finish date. is there a way of doing it just based on year selected in a drop down and a preset month?","categoryID":322,"dateInserted":"2021-02-23T20:05:47+00:00","dateUpdated":null,"dateLastComment":"2021-02-23T20:52:30+00:00","insertUserID":132395,"insertUser":{"userID":132395,"name":"Suzanne Burton","url":"https:\/\/community.smartsheet.com\/profile\/Suzanne%20Burton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!22Ddv-gE3eQ!XOteHwQWCLo!CEo6uPYZtIu","dateLastActive":"2023-05-22T13:50:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":132395,"lastUser":{"userID":132395,"name":"Suzanne Burton","url":"https:\/\/community.smartsheet.com\/profile\/Suzanne%20Burton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!22Ddv-gE3eQ!XOteHwQWCLo!CEo6uPYZtIu","dateLastActive":"2023-05-22T13:50:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":161,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76522\/sumif-by-year-and-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76522\/sumif-by-year-and-month","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-23T20:08:36+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":[],"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":76454,"type":"question","name":"Automation\/Updating","excerpt":"Hi all, Hoping to get some suggestions on something I'm stuck with. I have a master sheet that I replace all the contents once a week (via a mass copy and paste). I have a group that needs to add data to one of the columns, however I'm trying to find a way of avoiding them from having any type of write access to the master…","categoryID":322,"dateInserted":"2021-02-22T18:38:58+00:00","dateUpdated":null,"dateLastComment":"2021-02-23T20:15:51+00:00","insertUserID":122588,"insertUser":{"userID":122588,"name":"Carlos Yanes","url":"https:\/\/community.smartsheet.com\/profile\/Carlos%20Yanes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GJAQ9SLDSYK2\/nUWI1W2E5ZEZ4.jpg","dateLastActive":"2023-01-30T14:26:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":122588,"lastUser":{"userID":122588,"name":"Carlos Yanes","url":"https:\/\/community.smartsheet.com\/profile\/Carlos%20Yanes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/GJAQ9SLDSYK2\/nUWI1W2E5ZEZ4.jpg","dateLastActive":"2023-01-30T14:26:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":133,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76454\/automation-updating","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76454\/automation-updating","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-22T20:01:08+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":[],"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":76516,"type":"question","name":"Check a single box based on multiple Harvey balls","excerpt":"I have multiple rows listing activities for items A through J (arranged as columns). Each item has a Harvey ball to show its completion - e.g., half, three-quarters, full, etc. I would like for a checkbox column to be checked when all items' Harvey balls are full. What I want to do is this: =IF([Item A]@row:[Item J]@row =…","categoryID":322,"dateInserted":"2021-02-23T18:11:28+00:00","dateUpdated":null,"dateLastComment":"2021-02-23T20:12:17+00:00","insertUserID":132386,"insertUser":{"userID":132386,"name":"Marisa Jasso","url":"https:\/\/community.smartsheet.com\/profile\/Marisa%20Jasso","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xalfMTazN7o!!LxNcSROOv_-","dateLastActive":"2021-02-24T22:19:11+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-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":147,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76516\/check-a-single-box-based-on-multiple-harvey-balls","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76516\/check-a-single-box-based-on-multiple-harvey-balls","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-23T19:58:11+00:00","dateAnswered":"2021-02-23T18:15:25+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":[],"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":76486,"type":"question","name":"Formula to track duplicate text\/values across multiple columns","excerpt":"Hi there, Apologies if this question has been asked multiple times but i have searched across the forums and cannot seem to find a definite answer to a problem i'm trying to find a solution for. I have built a tracker to track web activities across our site encompassing language, page that the activity occurred on along…","categoryID":322,"dateInserted":"2021-02-23T10:44:08+00:00","dateUpdated":null,"dateLastComment":"2021-02-23T20:10:31+00:00","insertUserID":132349,"insertUser":{"userID":132349,"name":"Simon Haddock","url":"https:\/\/community.smartsheet.com\/profile\/Simon%20Haddock","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-05T13:50: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-08-19T20:19:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":113,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76486\/formula-to-track-duplicate-text-values-across-multiple-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76486\/formula-to-track-duplicate-text-values-across-multiple-columns","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-23T10:59:52+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":76515,"type":"question","name":"Prevent Cell Formula from being overwritten","excerpt":"I have a cell formula that will change the status of the parent cell (in this case Materials) to Green, when all of its children are either Green or Gray. However, since the sheet is shared amongst multiple people, it can be overwritten manually when someone changes the status to a different color then the properties of…","categoryID":322,"dateInserted":"2021-02-23T18:01:53+00:00","dateUpdated":null,"dateLastComment":"2021-02-23T20:07:26+00:00","insertUserID":132378,"insertUser":{"userID":132378,"name":"Lucas Argueza","url":"https:\/\/community.smartsheet.com\/profile\/Lucas%20Argueza","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-22T21: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-08-20T03:23:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":356,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/76515\/prevent-cell-formula-from-being-overwritten","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/76515\/prevent-cell-formula-from-being-overwritten","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-23T18:07: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":324,"urlcode":"community-platform","name":"Community Platform"}],"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}">

Help Article Resources