想要直接在智能表中练习使用公式吗?

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

公式和函数

被公式难住了?寻求帮助或找一些例子,看看别人是如何使用公式来解决类似的问题的。

讨论表

帮助文章参考资料欧宝体育app官方888

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
\"//www.santa-greenland.com/community/categories/formulas-and-functions/\")) * 100) + \"%\" Modified Formula with…","categoryID":322,"dateInserted":"2023-05-26T15:34:06+00:00","dateUpdated":null,"dateLastComment":"2023-05-26T21:34:47+00:00","insertUserID":146904,"insertUser":{"userID":146904,"name":"Kaleb","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hzlAoSbUIDs!hU_D4f686H8!MeM8OksBL1v","dateLastActive":"2023-05-26T21:10:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":146904,"lastUser":{"userID":146904,"name":"Kaleb","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hzlAoSbUIDs!hU_D4f686H8!MeM8OksBL1v","dateLastActive":"2023-05-26T21:10:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":42,"score":null,"hot":3370256933,"url":"https:\/\/community.smartsheet.com\/discussion\/105736\/adding-iferror-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105736\/adding-iferror-formula","format":"Rich","lastPost":{"discussionID":105736,"commentID":377796,"name":"Re: Adding IFERROR Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377796#Comment_377796","dateInserted":"2023-05-26T21:34:47+00:00","insertUserID":146904,"insertUser":{"userID":146904,"name":"Kaleb","url":"https:\/\/community.smartsheet.com\/profile\/Kaleb","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hzlAoSbUIDs!hU_D4f686H8!MeM8OksBL1v","dateLastActive":"2023-05-26T21:10: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-05-26T21:11:17+00:00","dateAnswered":"2023-05-26T19:52:18+00:00","acceptedAnswers":[{"commentID":377780,"body":"

What about this:<\/p>

=IFERROR(ROUND((COUNTIFS(CHILDREN(), OR(@cell = \"Pass\", @cell = \"Fail-4Front Review\", @cell = \"Fail-Shorr Review\", @cell = \"Re-Test Ready\")) \/ COUNTIFS(CHILDREN(), @cell <> \"//www.santa-greenland.com/community/categories/formulas-and-functions/\")) * 100) + \"%\", \"//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":[]},{"discussionID":105740,"type":"question","name":"Formula to count number of items if it matches both headings.","excerpt":"Hello, I am currently stuck on this formula. I'm not sure what I'm doing wrong but the formula keeps on providing a return of \"1\" for everything, when I know I have \"2\" counts of items which are under category 1 and have a status of in progress. =COUNT(COLLECT({Status}, $Label@row, {Project Category}, [Category 1]$1)) Any…","categoryID":322,"dateInserted":"2023-05-26T17:10:14+00:00","dateUpdated":null,"dateLastComment":"2023-05-26T20:18:53+00:00","insertUserID":160666,"insertUser":{"userID":160666,"name":"Joyce W","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Joyce%20W","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZYDq2b_lcvo!7rEq-_P-XHo!ATPah0gLcYz","dateLastActive":"2023-05-26T20:19:01+00:00","banned":0,"punished":0,"private":true,"label":"✭✭"},"updateUserID":null,"lastUserID":160666,"lastUser":{"userID":160666,"name":"Joyce W","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Joyce%20W","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZYDq2b_lcvo!7rEq-_P-XHo!ATPah0gLcYz","dateLastActive":"2023-05-26T20:19:01+00:00","banned":0,"punished":0,"private":true,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":43,"score":null,"hot":3370255147,"url":"https:\/\/community.smartsheet.com\/discussion\/105740\/formula-to-count-number-of-items-if-it-matches-both-headings","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105740\/formula-to-count-number-of-items-if-it-matches-both-headings","format":"Rich","lastPost":{"discussionID":105740,"commentID":377789,"name":"Re: Formula to count number of items if it matches both headings.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377789#Comment_377789","dateInserted":"2023-05-26T20:18:53+00:00","insertUserID":160666,"insertUser":{"userID":160666,"name":"Joyce W","title":"Business Analyst","url":"https:\/\/community.smartsheet.com\/profile\/Joyce%20W","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZYDq2b_lcvo!7rEq-_P-XHo!ATPah0gLcYz","dateLastActive":"2023-05-26T20:19:01+00:00","banned":0,"punished":0,"private":true,"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\/S9FSNBMUTXYC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-26T20:18:59+00:00","dateAnswered":"2023-05-26T18:31:55+00:00","acceptedAnswers":[{"commentID":377757,"body":"

Not sure you need \"COLLECT\" here (or the fixed reference to the Label column). <\/p>

Try this instead: =COUNTIFS({Status}, Label@row, {Project Category}, [Category 1]$1)<\/p>

I created some sample data (including a cross-sheet), and this worked.<\/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":105743,"type":"question","name":"How do I create an if blank then this and if populated then that statement?","excerpt":"Hello! Below is my current formula for a column to calculate days behind. =[Planned Start Date]@row - TODAY() The problem is we want this sheet to be accurate without having to have cells have different formulas. What I would like it to calculate is IF [Actual Start Date]@row is populated, then [Planned Start Date]@row -…","categoryID":322,"dateInserted":"2023-05-26T18:24:49+00:00","dateUpdated":null,"dateLastComment":"2023-05-26T18:47:05+00:00","insertUserID":161837,"insertUser":{"userID":161837,"name":"AMcElfresh","url":"https:\/\/community.smartsheet.com\/profile\/AMcElfresh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T19:50:53+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-05-27T21:31:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":94,"score":null,"hot":3370254114,"url":"https:\/\/community.smartsheet.com\/discussion\/105743\/how-do-i-create-an-if-blank-then-this-and-if-populated-then-that-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105743\/how-do-i-create-an-if-blank-then-this-and-if-populated-then-that-statement","format":"Rich","lastPost":{"discussionID":105743,"commentID":377764,"name":"Re: How do I create an if blank then this and if populated then that statement?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377764#Comment_377764","dateInserted":"2023-05-26T18:47:05+00:00","insertUserID":8888,"insertUser":{"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-05-27T21:31:18+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-05-26T18:42:42+00:00","dateAnswered":"2023-05-26T18:32:54+00:00","acceptedAnswers":[{"commentID":377758,"body":"

Hi @AMcElfresh<\/a> <\/p>

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

Try something like this.<\/p>

=IF([Actual Start Date]@row <> \"//www.santa-greenland.com/community/categories/formulas-and-functions/\", [Planned Start Date]@row - [Actual Start Date]@row, [Planned Start Date]@row - TODAY())<\/p>

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

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势