Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Sign in andask it here!The community's got your back.
Wondering if there’s a problem?
Check out theStatus Pageand subscribe for notifications.
Check what Support you have access to based on your Plan
Overview of Smartsheet support hours and resources
Share your knowledge!
Help others byanswering questions.
Formulas and Functions
Discussion List
Help Article Resources
Categories
Popular Tags
- Formulas10,469
- Project Management4,337
- Sheets3,656
- Reports2,551
- 形式2,322
- functionality2,113
- Automations1,758
- IT & Operations1,744
- Support1,522
- Cell linking1,510
- Enhancement Request1,489
- Email Notifications1,377
- Account and User Management1,373
- Integrations1,213
- Conditional Formatting1,184
- Dashboards1,168
- Construction1,085
- API and Developers884
- Sharing and Collaboration876
- Manufacturing862
- Update Requests802
- Workflows in Smartsheet781
- Gantt View775
- Product Development769
- Attachments764
You are basically looking for duplicates. Try something like this in a flag type column:<\/p>
=IF(COUNTIFS([Assigned To]:[Assigned To], @cell = [Assigned To]@row, [Due Date]:[Due Date], @cell = [Due Date]@row)> 1, 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107659,"type":"question","name":"How to make Parent helper column reflect values based on Children values with multiple conditions","excerpt":"I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…","snippet":"I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column…","categoryID":322,"dateInserted":"2023-07-17T01:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-17T03:11:33+00:00","insertUserID":157192,"insertUser":{"userID":157192,"name":"decrom","url":"https:\/\/community.smartsheet.com\/profile\/decrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-17T03:18:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":112221,"lastUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T17:49:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3379122318,"url":"https:\/\/community.smartsheet.com\/discussion\/107659\/how-to-make-parent-helper-column-reflect-values-based-on-children-values-with-multiple-conditions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107659\/how-to-make-parent-helper-column-reflect-values-based-on-children-values-with-multiple-conditions","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107659,"commentID":385499,"name":"Re: How to make Parent helper column reflect values based on Children values with multiple conditions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385499#Comment_385499","dateInserted":"2023-07-17T03:11:33+00:00","insertUserID":112221,"insertUser":{"userID":112221,"name":"Kelly Moore","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kelly%20Moore","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jnPa4zng1Pw!n1lbH6Wxgbo!UbxYNkVsKJw","dateLastActive":"2023-07-17T17:49:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/8JA27C48KJIR\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-17T02:55:22+00:00","dateAnswered":"2023-07-17T02:36:04+00:00","acceptedAnswers":[{"commentID":385496,"body":"
