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.
❓️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.

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

5, [Days (Difference Forecast - Baseline)]1 <= 10), \"Amber\", \"Red\")) which is working efficiently, but problem occurs when the cell is empty, and it show me…","categoryID":322,"dateInserted":"2019-04-04T10:18:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-10T06:30:55+00:00","insertUserID":84161,"insertUser":{"userID":84161,"name":"SBash","url":"https:\/\/community.smartsheet.com\/profile\/SBash","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-17T11:10: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-07-11T23:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":4552,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/45041\/if-cell-is-empty-or-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45041\/if-cell-is-empty-or-blank","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":207,"urlcode":"Sales","name":"Sales"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":45501,"type":"discussion","name":"Product Selection using Contacts","excerpt":"Hi Just thinking aloud... is there any reason why I couldn't import my product inventory into 'contacts' and use the 'contacts' feature as 'products' and be able to select multiple products in one cell on a row? And then do counts of products within a sheet or a selection of rows? Thanks Cheers Richard","categoryID":322,"dateInserted":"2019-04-10T03:22:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-10T04:43:37+00:00","insertUserID":1696,"insertUser":{"userID":1696,"name":"Richard","url":"https:\/\/community.smartsheet.com\/profile\/Richard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-05T10:41:07+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-07-11T23:43:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":72,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45501\/product-selection-using-contacts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45501\/product-selection-using-contacts","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":247,"urlcode":"Contacts","name":"Contacts"},{"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":45461,"type":"discussion","name":"Data Matrix for dashboard - cross sheet formulas","excerpt":"I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: \"Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…","categoryID":322,"dateInserted":"2019-04-09T13:22:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T16:29:23+00:00","insertUserID":78806,"insertUser":{"userID":78806,"name":"pkitzens","url":"https:\/\/community.smartsheet.com\/profile\/pkitzens","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-12T21:42:39+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-11T19:04:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":614,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45461\/data-matrix-for-dashboard-cross-sheet-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45461\/data-matrix-for-dashboard-cross-sheet-formulas","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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":220,"urlcode":"Hospitality","name":"Hospitality"},{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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":45456,"type":"discussion","name":"Multiply across columns, then sum children","excerpt":"I would like to use the sum children formula, however the calculation includes other columns before it can sum. The month column contains number of units, while the cost of each unit is in another column. The sum for the month = #units * cost per unit. Can the children formula be used so that the formula doesn't have to be…","categoryID":322,"dateInserted":"2019-04-09T12:58:34+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T15:01:54+00:00","insertUserID":10036,"insertUser":{"userID":10036,"name":"Clinical Research Industry User","url":"https:\/\/community.smartsheet.com\/profile\/Clinical%20Research%20Industry%20User","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-09T11:48:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T17:47:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":353,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45456\/multiply-across-columns-then-sum-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45456\/multiply-across-columns-then-sum-children","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-04\/cf\/7a\/cf7acc7d0d7c3acca5ba6c49d3f4a208.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.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":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":45421,"type":"discussion","name":"Checking if a cell has absolutely nothing in it","excerpt":"I have a sheet where I have needed to suppress any errors with ISERROR function. The formulas are showing blank now because division by zero errors are suppressed. The formulas will show data when data is entered in other cells. The issue is when someone adds a row to the sheet, I want to make it apparent that they forgot…","categoryID":322,"dateInserted":"2019-04-09T09:07:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T13:18:57+00:00","insertUserID":84761,"insertUser":{"userID":84761,"name":"gtibalde","url":"https:\/\/community.smartsheet.com\/profile\/gtibalde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-09T08:57: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-11T19:04:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":201,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/45421\/checking-if-a-cell-has-absolutely-nothing-in-it","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45421\/checking-if-a-cell-has-absolutely-nothing-in-it","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"},{"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":45401,"type":"discussion","name":"How t set a default value to Symbol column","excerpt":"Hello! I have a symbol column with 3 options representing payment status, (Yes, No, Hold). By default it should be \"Hold\" until the user choses if the payment was accepted or rejected, so what I would like is that whenever a new row is filled, the symbol cell should be set to \"Hold\" by default. I know formulas don't work…","categoryID":322,"dateInserted":"2019-04-09T07:04:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T11:35:47+00:00","insertUserID":84746,"insertUser":{"userID":84746,"name":"AdamK","url":"https:\/\/community.smartsheet.com\/profile\/AdamK","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-09T06:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-07-06T18:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":384,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/45401\/how-t-set-a-default-value-to-symbol-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45401\/how-t-set-a-default-value-to-symbol-column","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":207,"urlcode":"Sales","name":"Sales"},{"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":45371,"type":"discussion","name":"Countifs with multiple variables","excerpt":"I am trying to automate a tally of which SME's have worked an event with which countries. Ultimately, I created a column that lists the countries that participated in the particular event (ideally I would like to keep multiple countries in one cell per event), and hoped to use the \"joined\" column to reference the SME's…","categoryID":322,"dateInserted":"2019-04-08T17:56:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T11:27:00+00:00","insertUserID":17836,"insertUser":{"userID":17836,"name":"Shesha_K","url":"https:\/\/community.smartsheet.com\/profile\/Shesha_K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/55\/a6\/n55a6a4afb04f11891cef2abdcc8143ba.jpg","dateLastActive":"2023-06-09T21:23:09+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-11T19:04:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":82,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45371\/countifs-with-multiple-variables","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45371\/countifs-with-multiple-variables","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-04\/a4\/33\/a4337bbc4fa2dd37fbf3074859fd1956.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet3.PNG"},"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":263,"urlcode":"Government","name":"Government"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":26726,"type":"discussion","name":"Smartsheet users in The Netherlands","excerpt":"Hello, We're using Smartsheet in our R&D department to manage product development. In order for us to make a next step in using Smartsheet functionality and building more complex dashboards, we are looking for Smartsheet users in The Netherlands or Benelux. Please reach out to me if you are or know someone. Thanks, Rob","categoryID":322,"dateInserted":"2018-06-11T12:03:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T10:13:28+00:00","insertUserID":50856,"insertUser":{"userID":50856,"name":"Rob Selker","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20Selker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-11T11:59:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":3696,"lastUser":{"userID":3696,"name":"Maaik Meijerink","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Maaik%20Meijerink","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/8b\/13\/n8b1398d67fe5121c5d6145d9907fae1b.jpg","dateLastActive":"2023-01-30T16:40:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":338,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/26726\/smartsheet-users-in-the-netherlands","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26726\/smartsheet-users-in-the-netherlands","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":215,"urlcode":"Templates","name":"Templates"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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":45261,"type":"discussion","name":"One column to read multiple if\/and criteria and populate","excerpt":"O.K., I have a detailed question so please bear with me: I currently have the following formula that works at the moment: =IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = \"Closed\"), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = \"Open\"), \"Open Issue\", IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = \"Pending\"), \"Open…","categoryID":322,"dateInserted":"2019-04-08T09:11:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-04-09T09:35:21+00:00","insertUserID":76836,"insertUser":{"userID":76836,"name":"Mykul69","url":"https:\/\/community.smartsheet.com\/profile\/Mykul69","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-12T13:51:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T17:47:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":71,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/45261\/one-column-to-read-multiple-if-and-criteria-and-populate","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/45261\/one-column-to-read-multiple-if-and-criteria-and-populate","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!
Give this a try:<\/p>

=IFERROR(<\/strong>INDEX({Updates}, MATCH([Auto number]@row, {Auto Number}, 0)), \"//www.santa-greenland.com/community/categories/formulas-and-functions/\")<\/strong><\/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":[]},{"discussionID":107451,"type":"question","name":"Formula for Symbols","excerpt":"Hello! hope this is easy enough but im still trying to master my formulas with symbols. Can anyone help me with this one? I need to use the symbol to indicate if current month is more, less or same as prior month @row","snippet":"Hello! hope this is easy enough but im still trying to master my formulas with symbols. Can anyone help me with this one? I need to use the symbol to indicate if current month is…","categoryID":322,"dateInserted":"2023-07-11T16:05:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-11T18:04:18+00:00","insertUserID":146602,"insertUser":{"userID":146602,"name":"ldavenportHAP","url":"https:\/\/community.smartsheet.com\/profile\/ldavenportHAP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-11T19:18:52+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-11T19:04:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":40,"score":null,"hot":3378191965,"url":"https:\/\/community.smartsheet.com\/discussion\/107451\/formula-for-symbols","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107451\/formula-for-symbols","format":"Rich","lastPost":{"discussionID":107451,"commentID":384657,"name":"Re: Formula for Symbols","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384657#Comment_384657","dateInserted":"2023-07-11T18:04:18+00:00","insertUserID":45516,"insertUser":{"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-11T19:04:43+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\/8MI9TMLH9T8J\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-11T16:47:57+00:00","dateAnswered":"2023-07-11T16:32:51+00:00","acceptedAnswers":[{"commentID":384626,"body":"

You would use a nested IF statement.<\/p>

=IF([AR Days Current Month]@row>[AR Days Prior Month]@row, \"up arrow\", IF([AR Days Current Month]@row<[AR Days Prior Month]@row, \"down arrow\", \"right arrow\"))<\/p>


<\/p>

You will need to replace each \"directional arrow\" with the appropriate text value. You can find out what text values to use by clicking on one of the cells in the symbol column and expanding the options as if you are going to manually select them.<\/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":[]},{"discussionID":107449,"type":"question","name":"A formula to calculate 10% of the Approved Budget","excerpt":"Hi I need help creating a formula to calculate 10% of the Approved Budget. Kind regards Marcy","snippet":"Hi I need help creating a formula to calculate 10% of the Approved Budget. Kind regards Marcy","categoryID":322,"dateInserted":"2023-07-11T15:59:51+00:00","dateUpdated":null,"dateLastComment":"2023-07-11T16:06:51+00:00","insertUserID":124101,"insertUser":{"userID":124101,"name":"Marcy Morris","url":"https:\/\/community.smartsheet.com\/profile\/Marcy%20Morris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dz9dQ1L6w_w!2mDRP2igUmQ!B-8HC7uSYxG","dateLastActive":"2023-07-11T16:07:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":124101,"lastUser":{"userID":124101,"name":"Marcy Morris","url":"https:\/\/community.smartsheet.com\/profile\/Marcy%20Morris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dz9dQ1L6w_w!2mDRP2igUmQ!B-8HC7uSYxG","dateLastActive":"2023-07-11T16:07:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":30,"score":null,"hot":3378184002,"url":"https:\/\/community.smartsheet.com\/discussion\/107449\/a-formula-to-calculate-10-of-the-approved-budget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107449\/a-formula-to-calculate-10-of-the-approved-budget","format":"Rich","lastPost":{"discussionID":107449,"commentID":384614,"name":"Re: A formula to calculate 10% of the Approved Budget","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384614#Comment_384614","dateInserted":"2023-07-11T16:06:51+00:00","insertUserID":124101,"insertUser":{"userID":124101,"name":"Marcy Morris","url":"https:\/\/community.smartsheet.com\/profile\/Marcy%20Morris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dz9dQ1L6w_w!2mDRP2igUmQ!B-8HC7uSYxG","dateLastActive":"2023-07-11T16:07:13+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-11T16:07:11+00:00","dateAnswered":"2023-07-11T16:03:39+00:00","acceptedAnswers":[{"commentID":384612,"body":"

Hi @Marcy Morris<\/a> <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=0.1 * [Approved Budget]@row<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Formulas and Functions