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

了一个公式吗?寻求帮助或找到的例子s to see how others use a formula to solve a similar problem.

Discussion List

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video
You have an extra comma in your formula before the close parenthesis for the AND<\/p>
\n
\n \n \"example.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Once you remove that, you should be set!<\/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":110956,"type":"question","name":"Formula IFS return values from other columns","excerpt":"Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named \"ETS\", but i want to add another if that return a value from column \"Business Dropdown\" if the column ETS is blank. This is the formula that i wrote now very simple and it is running well, but it is missing the…","snippet":"Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named \"ETS\", but i want to add another if that return a value from column…","categoryID":322,"dateInserted":"2023-09-28T20:10:28+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T20:35:00+00:00","insertUserID":140104,"insertUser":{"userID":140104,"name":"Raul Cabrera","url":"https:\/\/community.smartsheet.com\/profile\/Raul%20Cabrera","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WxHVX93-X34!CelZAvGm7jw!7qwcGhKSeo9","dateLastActive":"2023-09-28T20:50:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":165153,"lastUser":{"userID":165153,"name":"DKazatsky2","url":"https:\/\/community.smartsheet.com\/profile\/DKazatsky2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:51:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3391865728,"url":"https:\/\/community.smartsheet.com\/discussion\/110956\/formula-ifs-return-values-from-other-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110956\/formula-ifs-return-values-from-other-columns","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110956,"commentID":397531,"name":"Re: Formula IFS return values from other columns","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397531#Comment_397531","dateInserted":"2023-09-28T20:35:00+00:00","insertUserID":165153,"insertUser":{"userID":165153,"name":"DKazatsky2","url":"https:\/\/community.smartsheet.com\/profile\/DKazatsky2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:51:34+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\/ASKPITW4DU25\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-28T20:50:48+00:00","dateAnswered":"2023-09-28T20:35:00+00:00","acceptedAnswers":[{"commentID":397531,"body":"

Hi @Raul Cabrera<\/a> ,<\/p>

Give this try.<\/p>

=IF(ETS@row = \"//m.santa-greenland.com/community/categories/formulas-and-functions/\", [Business_Dropdown]@row, IF(ETS@row = \"EAS\", \"EAS\", IF(ETS@row = \"ETS\", \"ETS\")))<\/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":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110951,"type":"question","name":"Formula Help For Multiple Tags Within The Same Cell","excerpt":"Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag. For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These…","snippet":"Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the…","categoryID":322,"dateInserted":"2023-09-28T19:18:37+00:00","dateUpdated":null,"dateLastComment":"2023-09-28T20:04:52+00:00","insertUserID":166984,"insertUser":{"userID":166984,"name":"EmRo","title":"Senior Operations Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/EmRo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:00:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":166984,"lastUser":{"userID":166984,"name":"EmRo","title":"Senior Operations Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/EmRo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:00:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3391862009,"url":"https:\/\/community.smartsheet.com\/discussion\/110951\/formula-help-for-multiple-tags-within-the-same-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110951\/formula-help-for-multiple-tags-within-the-same-cell","format":"Rich","lastPost":{"discussionID":110951,"commentID":397526,"name":"Re: Formula Help For Multiple Tags Within The Same Cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397526#Comment_397526","dateInserted":"2023-09-28T20:04:52+00:00","insertUserID":166984,"insertUser":{"userID":166984,"name":"EmRo","title":"Senior Operations Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/EmRo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-28T20:00:35+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\/44ABE1FHZKC6\/call-categories-dashboard-image-2023-09-28.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Call Categories Dashboard_Image_2023-09-28.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-28T20:03:55+00:00","dateAnswered":"2023-09-28T19:57:29+00:00","acceptedAnswers":[{"commentID":397521,"body":"

Hi @EmRo<\/a> ,<\/p>

Trying using the HAS() function in your formula.<\/p>

=COUNTIF({Client Business Sim LIVE Call Characteristic}, HAS(@cell, Description@row))<\/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":[]}],"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

  • If formula for multiple check boxes.

    I have multiple columns with check boxes and I need a new column that validates if ALL are checked. I'm trying to create a formula that says: if column 2 is checked, AND column 3 is checked, AND column 4 is checked, 'yes' else 'no'. Any help is appreciated.

  • Formula IFS return values from other columns

    Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named "ETS", but i want to add another if that return a value from column "Business Dropdown" if the column ETS is blank. This is the formula that i wrote now very simple and it is running well, but it is missing the…

  • Formula Help For Multiple Tags Within The Same Cell

    Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag. For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These…