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.

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

.66>.9,\"Yellow,IF(AND[#…","categoryID":322,"dateInserted":"2018-08-16T08:22:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-16T10:50:21+00:00","insertUserID":55106,"insertUser":{"userID":55106,"name":"aellis55106","url":"https:\/\/community.smartsheet.com\/profile\/aellis55106","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-16T08:00:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/30766\/formula-help-please","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30766\/formula-help-please","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}]},{"discussionID":30621,"type":"discussion","name":"Match Two Entries from Two Separate Form Sheets, Assign Status","excerpt":"I have an \"Assignment\" form that creates a system generated number. The crew foreman will use this form for their assignment, then they will populate a \"Production\" form using the system generated number from the \"Assignment\" form to reflect the production done for that assignment. I'd like have a RYG ball on the…","categoryID":322,"dateInserted":"2018-08-14T13:29:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-15T14:38:29+00:00","insertUserID":58026,"insertUser":{"userID":58026,"name":"Chris Sams","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Sams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-14T12:59:08+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-24T20:19:17+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\/30621\/match-two-entries-from-two-separate-form-sheets-assign-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30621\/match-two-entries-from-two-separate-form-sheets-assign-status","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":204,"urlcode":"forms","name":"Forms"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":30566,"type":"discussion","name":"return list from another sheet","excerpt":"Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…","categoryID":322,"dateInserted":"2018-08-13T12:21:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-15T12:35:47+00:00","insertUserID":57846,"insertUser":{"userID":57846,"name":"Matt_w_questions","url":"https:\/\/community.smartsheet.com\/profile\/Matt_w_questions","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-13T12:18:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":460,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/30566\/return-list-from-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30566\/return-list-from-another-sheet","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":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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":30611,"type":"discussion","name":"Summing of colored \"conditional\" cells","excerpt":"Hello All, I am trying to count or sum how many colored cells there are within a row. The rows consist of test questions and are set to turn red if the condition is not met (answer is incorrect). Is there a way to sum all of the condition not met cells? There are 25 cells that have conditions in them.","categoryID":322,"dateInserted":"2018-08-14T09:55:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-15T08:49:20+00:00","insertUserID":57856,"insertUser":{"userID":57856,"name":"jjanusz","url":"https:\/\/community.smartsheet.com\/profile\/jjanusz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-16T17:42:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":610,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/30611\/summing-of-colored-conditional-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30611\/summing-of-colored-conditional-cells","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":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":30531,"type":"discussion","name":"Nested IF Then And Statment","excerpt":"I am trying to finalize a Nested If Then \/And Statement. In one of my logical functions, I am trying move to the next condition if a cell has a date input into. When I try to use the logic if cell > 0, it returns an error. What would be the best method for moving the formula to the next logical statement?","categoryID":322,"dateInserted":"2018-08-11T13:56:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-15T08:48:47+00:00","insertUserID":57751,"insertUser":{"userID":57751,"name":"Brad Worth","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Worth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/f9\/b9\/nf9b97f6a7777fd5b70784ff4d3cc8ba6.JPG","dateLastActive":"2018-08-11T14:20:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":57581,"lastUser":{"userID":57581,"name":"Javed Hassan","url":"https:\/\/community.smartsheet.com\/profile\/Javed%20Hassan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/7EOM552BKGGM\/nBHHPEBSCPTGK.jpg","dateLastActive":"2023-08-14T12:26:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":92,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/30531\/nested-if-then-and-statment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30531\/nested-if-then-and-statment","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":218,"urlcode":"construction","name":"Construction"},{"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":29161,"type":"discussion","name":"cell reference based on date","excerpt":"We have a yearly schedule for all our field guys that is updated a week prior and sent out to the field so everyone knows where they will be working for the upcoming week. My question is can I tie a roll up sheet to the master schedule sheet that I would input a date on the roll up and based on that date grab the matching…","categoryID":322,"dateInserted":"2018-07-24T17:07:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-15T08:32:41+00:00","insertUserID":55501,"insertUser":{"userID":55501,"name":"Patrick Eastman","url":"https:\/\/community.smartsheet.com\/profile\/Patrick%20Eastman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-04T17:56:26+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-24T20:19:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":1001,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/29161\/cell-reference-based-on-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/29161\/cell-reference-based-on-date","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":218,"urlcode":"construction","name":"Construction"},{"tagID":241,"urlcode":"calendar","name":"Calendar View"},{"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":30596,"type":"discussion","name":"Help on formula: countifs with multiple criteria","excerpt":"Hi everyone, I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image). The 2 sections are called Food and Non-Food. The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other terms applied in this…","categoryID":322,"dateInserted":"2018-08-14T08:27:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-15T01:43:35+00:00","insertUserID":42606,"insertUser":{"userID":42606,"name":"Grace","url":"https:\/\/community.smartsheet.com\/profile\/Grace","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-14T08:25:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":42606,"lastUser":{"userID":42606,"name":"Grace","url":"https:\/\/community.smartsheet.com\/profile\/Grace","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-14T08:25:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":155,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/30596\/help-on-formula-countifs-with-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30596\/help-on-formula-countifs-with-multiple-criteria","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-08\/8d\/ed\/8ded13f638a04509bdcdd9b5ab377d55.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Countif.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":285,"urlcode":"solution-center","name":"Solution Center"},{"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":30431,"type":"discussion","name":"Date changes to tomorrow after 5pm","excerpt":"Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…","categoryID":322,"dateInserted":"2018-08-09T16:40:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-14T12:36:00+00:00","insertUserID":27881,"insertUser":{"userID":27881,"name":"bhope51","url":"https:\/\/community.smartsheet.com\/profile\/bhope51","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-04T18:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":27881,"lastUser":{"userID":27881,"name":"bhope51","url":"https:\/\/community.smartsheet.com\/profile\/bhope51","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-04T18:44:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":253,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/30431\/date-changes-to-tomorrow-after-5pm","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/30431\/date-changes-to-tomorrow-after-5pm","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-08\/cc\/e8\/cce816be31b4fb094e136c88fd6cd539.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.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":219,"urlcode":"sheets","name":"Sheets"},{"tagID":249,"urlcode":"education","name":"Education"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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公式手册模板!
This will work for instances where there is a single first and single last name, separated by a space. If you get into more complicated names, things get harder to work out.<\/p>

=IF([Name]@row <> \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", LEFT([Name]@row, FIND(\" \", [Name]@row) - 1) + \".\" + RIGHT([Name]@row, LEN([Name]@row) - FIND(\" \", [Name]@row)) + \"@company.net\", \"//www.santa-greenland.com/community/categories/formulas-and-functions/\")<\/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":109441,"type":"question","name":"SumIFS from another sheet with two conditions","excerpt":"I am trying to use the SUMIFS function to sum the total budget approved for one of the Functions when the STEP is only In-Flight. This is the formula I am using, but it's not working! =SUMIFS({Projects Function}, CONTAINS(\"Finance\"), {Projects Step}, CONTAINS(\"6 - In Flight\"), {Budget}, >25) I need the data from another…","snippet":"I am trying to use the SUMIFS function to sum the total budget approved for one of the Functions when the STEP is only In-Flight. This is the formula I am using, but it's not…","categoryID":322,"dateInserted":"2023-08-24T22:12:04+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T13:11:07+00:00","insertUserID":165562,"insertUser":{"userID":165562,"name":"nermine.elsaghir","title":"Senior Analyst, PMO","url":"https:\/\/community.smartsheet.com\/profile\/nermine.elsaghir","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T13:08:37+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"updateUserID":null,"lastUserID":165562,"lastUser":{"userID":165562,"name":"nermine.elsaghir","title":"Senior Analyst, PMO","url":"https:\/\/community.smartsheet.com\/profile\/nermine.elsaghir","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T13:08:37+00:00","banned":0,"punished":0,"private":true,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3385885391,"url":"https:\/\/community.smartsheet.com\/discussion\/109441\/sumifs-from-another-sheet-with-two-conditions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109441\/sumifs-from-another-sheet-with-two-conditions","format":"Rich","lastPost":{"discussionID":109441,"commentID":392558,"name":"Re: SumIFS from another sheet with two conditions","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392558#Comment_392558","dateInserted":"2023-08-25T13:11:07+00:00","insertUserID":165562,"insertUser":{"userID":165562,"name":"nermine.elsaghir","title":"Senior Analyst, PMO","url":"https:\/\/community.smartsheet.com\/profile\/nermine.elsaghir","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T13:08:37+00:00","banned":0,"punished":0,"private":true,"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-08-25T13:32:17+00:00","dateAnswered":"2023-08-24T23:10:18+00:00","acceptedAnswers":[{"commentID":392505,"body":"

Hi @nermine.elsaghir<\/a> ,<\/p>

It looks like you are missing the range of what you want summed, which I assume is {Budget} - this should be the first argument in the formula. Additionally, is the values you are are using for your criteria are the entire values of the cell, you do not need to use \"CONTAINS\" (again, I am making an assumption that this is the case).<\/p>

Try this: =SUMIFS({Budget}, {Projects Function}, \"Finance\", {Projects Step}, \"6 - In Flight\", {Budget}, >25) <\/p>

Hope this helps,<\/p>

Dave<\/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":109392,"type":"question","name":"COUNTIF using OR","excerpt":"Hi, I'm trying to count how many check boxes (out of a possible 4) are checked on a row (basically, countif w OR x OR y OR z is checked). I've tried many variations of the following formula: =COUNTIFS(OR[PNS]@row = \"1\", [EIP]@row = \"1\")) Thank you!","snippet":"Hi, I'm trying to count how many check boxes (out of a possible 4) are checked on a row (basically, countif w OR x OR y OR z is checked). I've tried many variations of the…","categoryID":322,"dateInserted":"2023-08-24T13:49:46+00:00","dateUpdated":null,"dateLastComment":"2023-08-24T17:10:27+00:00","insertUserID":141331,"insertUser":{"userID":141331,"name":"deb_63_hydracor","url":"https:\/\/community.smartsheet.com\/profile\/deb_63_hydracor","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AATXAJzYn23TqUOGU8A4PW0HalCwzLK5YNQsVxHwYcgL=s96-c","dateLastActive":"2023-08-24T15:43:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T13:29:47+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":62,"score":null,"hot":3385786213,"url":"https:\/\/community.smartsheet.com\/discussion\/109392\/countif-using-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109392\/countif-using-or","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109392,"commentID":392393,"name":"Re: COUNTIF using OR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392393#Comment_392393","dateInserted":"2023-08-24T17:10:27+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-25T13:29:47+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-08-24T15:57:53+00:00","dateAnswered":"2023-08-24T14:47:28+00:00","acceptedAnswers":[{"commentID":392343,"body":"

If your column title contains a space, it must be surrounded with square brackets. This should fix it.<\/p>

=COUNTIFS(PNS@row, 1) + COUNTIFS(EIP@row, 1) + COUNTIFS(Facilities@row, 1) + COUNTIFS([Patient Care Experience]@row, 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"}]}],"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