想直接在Smartsheet中练习使用公式吗?

请查看公式手册模板查看100多个公式，包括每个函数的词汇表以及常用和高级公式的示例。

公式与函数

被公式难住了?寻求帮助或寻找例子，看看其他人如何使用公式来解决类似的问题。

讨论表

帮助文章资源欧宝体育app官方888

在Smartsheet中创建和编辑公式

交叉表参考的公式组合

Smartsheet功能列表

类别

受欢迎的标签

Join us for a free virtual event for all registered Smartsheet Community Members, where you can: <\/p>

- Get to know other Members from around the world<\/p>

- Meet some of our newly inducted Community Champions<\/p>

- Give the Smartsheet team feedback on new projects we have planned, and more<\/p>

Plus, we'll be doing a giveaway at the end, and you know you don't want to miss that. <\/p>

\n
\n \n \"CVP-2-01.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>","excerpt":"Join us for a free virtual event for all registered Smartsheet Community Members, where you can: - Get to know other Members from around the world - Meet some of our newly inducted Community Champions - Give the Smartsheet team feedback on new projects we have planned, and more Plus, we'll be doing a giveaway at the end,…","location":"Zoom","locationUrl":"https:\/\/smartsheet.zoom.us\/webinar\/register\/WN_guQl71N1SVa4njpdp4yJyw","safeLocationUrl":"https:\/\/smartsheet.zoom.us\/webinar\/register\/WN_guQl71N1SVa4njpdp4yJyw","attending":null,"dateStarts":"2023-01-24T16:30:00+00:00","dateEnds":"2023-01-24T17:30:00+00:00","allDayEvent":false,"dateInserted":"2023-01-17T17:20:42+00:00","insertUserID":124375,"insertUser":{"userID":124375,"name":"Maxwell Griffith","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Maxwell%20Griffith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nSKJ2BAYVP7XH.png","dateLastActive":"2023-01-20T18:28:43+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"dateUpdated":"2023-01-17T17:28:27+00:00","updateUserID":124375,"updateUser":{"userID":124375,"name":"Maxwell Griffith","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Maxwell%20Griffith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nSKJ2BAYVP7XH.png","dateLastActive":"2023-01-20T18:28:43+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"permissions":{"Organizer":false,"Create":false,"Edit":false,"Member":false,"View":true,"Attend":true},"url":"https:\/\/community.smartsheet.com\/events\/74-start-2023-with-smartsheet-community","image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BODU19N3MJMK\/cvp-2-01.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CVP-2-01.png"}}],"viewMoreLink":"https:\/\/community.smartsheet.com\/events\/category","title":"Upcoming Events"}">

想直接在Smartsheet中练习使用公式吗?

请查看公式手册模板!
@LDenton<\/a> okay, looks like you just have some parenthesis in the wrong place. Try this<\/p>

=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row), [Date Closed]@row, TODAY())), 0)<\/p>

also keep in mind that the today formula will only work if you open and save the sheet. Refer to this help article if you need it to update every day without opening the sheet.<\/p>

Automatically update the TODAY function in formulas | Smartsheet Learning Center<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-20 19:44:39","updateUser":{"userID":157167,"name":"LDenton","url":"https:\/\/community.smartsheet.com\/profile\/LDenton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-20T23:22:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}]},{"discussionID":99963,"type":"question","name":"Formula for return X value if there is ANY text in a cell, otherwise return text in another cell","excerpt":"Hi! I am working on a formula for a sheet that has a product column, a Use Cases column and a Tool column. I'm hoping to use a formula that says, \"Look in the Use Cases column for any text. If you find text, return a \"Use Case\" in the Product column. If you can't find any words, then return the value in the Tool column in…","categoryID":322,"dateInserted":"2023-01-20T17:56:42+00:00","dateUpdated":null,"dateLastComment":"2023-01-20T18:22:23+00:00","insertUserID":134568,"insertUser":{"userID":134568,"name":"Bria Berger","url":"https:\/\/community.smartsheet.com\/profile\/Bria%20Berger","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xIDdcQgNK3Q!7GjeOygTRaQ!lRDj4QDXkTv","dateLastActive":"2023-01-20T18:48:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":134568,"lastUser":{"userID":134568,"name":"Bria Berger","url":"https:\/\/community.smartsheet.com\/profile\/Bria%20Berger","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xIDdcQgNK3Q!7GjeOygTRaQ!lRDj4QDXkTv","dateLastActive":"2023-01-20T18:48:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":45,"score":null,"hot":3348478745,"url":"https:\/\/community.smartsheet.com\/discussion\/99963\/formula-for-return-x-value-if-there-is-any-text-in-a-cell-otherwise-return-text-in-another-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99963\/formula-for-return-x-value-if-there-is-any-text-in-a-cell-otherwise-return-text-in-another-cell","format":"Rich","lastPost":{"discussionID":99963,"commentID":358045,"name":"Re: Formula for return X value if there is ANY text in a cell, otherwise return text in another cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/358045#Comment_358045","dateInserted":"2023-01-20T18:22:23+00:00","insertUserID":134568,"insertUser":{"userID":134568,"name":"Bria Berger","url":"https:\/\/community.smartsheet.com\/profile\/Bria%20Berger","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xIDdcQgNK3Q!7GjeOygTRaQ!lRDj4QDXkTv","dateLastActive":"2023-01-20T18:48:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"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\/1QKZMK98EKQC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-20T18:57:09+00:00","dateAnswered":"2023-01-20T18:19:38+00:00","acceptedAnswers":[{"commentID":358044,"body":"

@Bria Berger<\/a> <\/p>

Oops, sorry about that. How about this one?<\/p>

=IF([Use Cases]@row <> \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", \"Use Case\", Tool@row)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-20 18:57:09","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-01-21T02:23:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":99951,"type":"question","name":"Return Text from the Left of \"(\"","excerpt":"Hello, I need to return a 11 characters from the left of a parenthesis from a string of text. For example T0000000001 T0000000002 T0000000003 (Primary Case) I need the formula to return only the 11 characters from the left of \"(Primary Case)\" T000000003","categoryID":322,"dateInserted":"2023-01-20T15:55:24+00:00","dateUpdated":null,"dateLastComment":"2023-01-20T16:32:58+00:00","insertUserID":127841,"insertUser":{"userID":127841,"name":"Miles Allison","url":"https:\/\/community.smartsheet.com\/profile\/Miles%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-20T16:30:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":127841,"lastUser":{"userID":127841,"name":"Miles Allison","url":"https:\/\/community.smartsheet.com\/profile\/Miles%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-20T16:30:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3348463702,"url":"https:\/\/community.smartsheet.com\/discussion\/99951\/return-text-from-the-left-of","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99951\/return-text-from-the-left-of","format":"Rich","lastPost":{"discussionID":99951,"commentID":357999,"name":"Re: Return Text from the Left of \"(\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357999#Comment_357999","dateInserted":"2023-01-20T16:32:58+00:00","insertUserID":127841,"insertUser":{"userID":127841,"name":"Miles Allison","url":"https:\/\/community.smartsheet.com\/profile\/Miles%20Allison","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-20T16:30:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-20T18:23:45+00:00","dateAnswered":"2023-01-20T16:20:53+00:00","acceptedAnswers":[{"commentID":357993,"body":"

Hi @Miles Allison<\/a>,<\/p>

If this text string is in a single cell, you can do this using:<\/p>

=MID([Column Name]@row, FIND(\"(\", [Column Name]@row) - 12, 11)<\/p>

Obviously you need to change out \"Column Name\" for the header of the column the text is in, but this should work providing there is only a single instance of an open bracket in your text string.<\/p>

Hope this helps!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-20 18:23:45","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-01-21T02:23:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">