Want to practice working with formulas directly in Smartsheet?
Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Check out theFormula Handbook templateto view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
❓️Product questions
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.
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
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
\"//www.santa-greenland.com/community/categories/formulas-and-functions/\", {AutomatedCourseCopy-UseinBCC}, <>\"//www.santa-greenland.com/community/categories/formulas-and-functions/\", {AutomatedCourseCopy-College}, CRN1), \",…","categoryID":322,"dateInserted":"2019-06-03T17:32:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-05T04:02:23+00:00","insertUserID":74206,"insertUser":{"userID":74206,"name":"Art Schneiderheinze","url":"https:\/\/community.smartsheet.com\/profile\/Art%20Schneiderheinze","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PI7JNYDF7Q80\/nTL55D89VG7YK.png","dateLastActive":"2022-03-03T01:36:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":80301,"lastUser":{"userID":80301,"name":"Debbie Sawyer","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Sawyer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-02\/6f\/d1\/n6fd11e91b71000f2b152e84c8f072631.jpg","dateLastActive":"2023-07-27T10:42:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":732,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/49706\/join-collect-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49706\/join-collect-criteria","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":219,"urlcode":"Sheets","name":"Sheets"},{"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":49481,"type":"discussion","name":"Time in 24 hours","excerpt":"Please help! I am working on a IT Change Request sheet where the request is submitted by Forms. For a change to take place we require a specific time to be entered. I know Smartsheet currently does not have a time option, but is it possible to have the Implementation Time, whether it's entered as AM or PM or in a 24 hour…","categoryID":322,"dateInserted":"2019-05-30T18:52:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-04T12:35:41+00:00","insertUserID":81926,"insertUser":{"userID":81926,"name":"Tori Peregoy","url":"https:\/\/community.smartsheet.com\/profile\/Tori%20Peregoy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/20\/6d\/n206d2edc6cfadf37620be540eb41c2fc.jpg","dateLastActive":"2019-07-29T15:58: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-07-28T00:33:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":1118,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/49481\/time-in-24-hours","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49481\/time-in-24-hours","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-05\/a2\/70\/a270b0a6dd201a90c30c9f1889a82c23.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CC Time.jpg"},"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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":49731,"type":"discussion","name":"How to set a cell value based on another column. If false do nothing to original value","excerpt":"I have a status column that is a dropdown list. I also have another date column \"Goods and Services Received\" that pulls a date using a VLOOKUP from another smartsheet. What I am trying to do is change the status column to \"Complete\" if there is a date in the \"Goods and Services Received\" column of the reference sheet, but…","categoryID":322,"dateInserted":"2019-06-04T09:40:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-06-04T12:35:10+00:00","insertUserID":11369,"insertUser":{"userID":11369,"name":"Adam Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Adam%20Wilson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/9d\/ea\/n9deada715e76a36d441bae2325ea73e2.jpg","dateLastActive":"2021-11-15T16:24:04+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-07-28T00:33:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":813,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/49731\/how-to-set-a-cell-value-based-on-another-column-if-false-do-nothing-to-original-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/49731\/how-to-set-a-cell-value-based-on-another-column-if-false-do-nothing-to-original-value","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"}],"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
Categories
Popular Tags
- Formulas10,545
- Project Management4,347
- Sheets3,686
- Reports2,561
- 形式2,338
- functionality2130年
- Automations1,786
- IT & Operations1,745
- Support1,530
- Cell linking1,521
- Enhancement Request1,499
- Email Notifications1,380
- Account and User Management1,376
- Integrations1,217
- Conditional Formatting1,192
- Dashboards1,187
- Construction1,087
- API and Developers885
- Sharing and Collaboration878
- Manufacturing863
- Update Requests805
- Workflows in Smartsheet800
- Gantt View778
- Product Development775
- Attachments767
Does this work?<\/p>