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,467
- Project Management4,337
- Sheets3,655
- Reports2,549
- 形式2,321
- functionality2,112
- Automations1,758
- IT & Operations1,744
- Support1,522
- Cell linking1,509
- Enhancement Request1,488
- Email Notifications1,377
- Account and User Management1,372
- Integrations1,213
- Conditional Formatting1,184
- Dashboards1,167
- Construction1,085
- API and Developers884
- Sharing and Collaboration876
- Manufacturing862
- Update Requests802
- Workflows in Smartsheet781
- Gantt View775
- Product Development769
- Attachments763
Try this and see if it produces the expected result. Please be sure to test one 'In Process' with ZERO 'Untrained'. Was this what you expected?<\/p>
=IF(COUNT(CHILDREN(Proficiency@row)) > 0, IF(COUNT(CHILDREN(Proficiency@row)) = COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\"), \"Untrained\", IF(AND(COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\") >= 1, COUNT(CHILDREN(Proficiency@row)) > COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\")), \"In Progress\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"In Process\") >= 1, \"In Process\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Trained\") >= 1, \"Trained\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Proficient\") >= 1, \"Proficient\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Preceptor\") >= 1, \"Preceptor\")))))))<\/p>
Please let me know what we need to tweak<\/p>
Kelly<\/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":107647,"type":"question","name":"Formula help","excerpt":"Can someone help me with this formula. Right now it works correctly only when a date is in the warranty start column. However when there is no date in the warranty start date column is says invalid data type. So I think I am missing some command with \"//www.santa-greenland.com/community/categories/formulas-and-functions/\" but now sure where or how it should be written. Thanks","snippet":"Can someone help me with this formula. Right now it works correctly only when a date is in the warranty start column. However when there is no date in the warranty start date…","categoryID":322,"dateInserted":"2023-07-15T14:38:50+00:00","dateUpdated":null,"dateLastComment":"2023-07-15T15:42:03+00:00","insertUserID":144391,"insertUser":{"userID":144391,"name":"Jon Barto","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Barto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-15T15:37:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":66106,"lastUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-07-15T15:41:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":51,"score":null,"hot":3378871853,"url":"https:\/\/community.smartsheet.com\/discussion\/107647\/formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107647\/formula-help","format":"Rich","lastPost":{"discussionID":107647,"commentID":385476,"name":"Re: Formula help","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385476#Comment_385476","dateInserted":"2023-07-15T15:42:03+00:00","insertUserID":66106,"insertUser":{"userID":66106,"name":"Peggy Parchert","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Peggy%20Parchert","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/YYRDMWWFX83G\/nC7HLGW82ACPT.jpg","dateLastActive":"2023-07-15T15:41:25+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\/8EEBFF0ESKU2\/date-formula.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"date formula.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-17T08:26:54+00:00","dateAnswered":"2023-07-15T15:37:30+00:00","acceptedAnswers":[{"commentID":385474,"body":"
Bro! that was it! Thank you, I would not thought to use CountM(Collect for this at all. <\/p>
