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

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

公式和函数

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

讨论表

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

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

请查看公式手册模板!
Hi @cghallo_Veolia<\/a> <\/p>

I think you may have your criteria's in the wrong order? instead of:<\/p>

=INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)<\/em><\/p>

Try:<\/p>

=INDEX(COLLECT({Available}, {Who}, Rescheduled@row, {When}, Start@row ), 1)<\/strong><\/p>

Did that work?<\/p>

Hope that helps,<\/p>

Thanks Paul<\/p>"},{"commentID":373136,"body":"

Thanks, @Paul McGuinness<\/a>!<\/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":505,"urlcode":"scheduling","name":"Scheduling"}]},{"discussionID":104366,"type":"question","name":"How to prevent Smartsheet from Rounding Dates","excerpt":"Hello, I'm having trouble with Smartsheet rounding Sundays to Mondays and need help with my formula below. I'm using the Created Date column to capture when a submission is filed into our Sheet and another to capture Weeknumber. However, Smartsheet keeps rounding the Sunday entries to Monday if they occur after a certain…","categoryID":322,"dateInserted":"2023-04-24T12:14:55+00:00","dateUpdated":"2023-04-24T12:36:10+00:00","dateLastComment":"2023-04-25T03:31:15+00:00","insertUserID":151284,"insertUser":{"userID":151284,"name":"mcashoili","url":"https:\/\/community.smartsheet.com\/profile\/mcashoili","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-25T21:06:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":151284,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-04-25T22:28:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":39,"score":null,"hot":3364733770,"url":"https:\/\/community.smartsheet.com\/discussion\/104366\/how-to-prevent-smartsheet-from-rounding-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104366\/how-to-prevent-smartsheet-from-rounding-dates","format":"Rich","lastPost":{"discussionID":104366,"commentID":373124,"name":"Re: How to prevent Smartsheet from Rounding Dates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373124#Comment_373124","dateInserted":"2023-04-25T03:31:15+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-04-25T22:28:04+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\/49DMZGM3SP69\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-24T16:34:48+00:00","dateAnswered":"2023-04-24T16:02:56+00:00","acceptedAnswers":[{"commentID":373019,"body":"

@mcashoili<\/a> Sounds like you need to create a \"Local Date\" column to translate the Smartsheet server time into the local date. I just happen to have made a video about this and it should tell you all you need to know!<\/p>

\n \n https:\/\/youtu.be\/S-GsCr9wA5g\n <\/a>\n<\/div>


<\/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":104384,"type":"question","name":"IF Formula","excerpt":"This is my first time creating an IF formula. I think it should be easy for someone who knows what they are doing, so I hope you can help me. I'm trying to compare two date columns. If both columns have the same date, it should return 'SAME\", if they're different dates, it should return \"DIFFERENT\". Could someone please…","categoryID":322,"dateInserted":"2023-04-24T16:54:04+00:00","dateUpdated":null,"dateLastComment":"2023-04-24T20:13:36+00:00","insertUserID":160809,"insertUser":{"userID":160809,"name":"Debbie Magee","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Magee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!239XP1W05fo!xFlWsXWh6To!iCDqtuSpM4i","dateLastActive":"2023-04-24T19:57:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":160809,"lastUser":{"userID":160809,"name":"Debbie Magee","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Magee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!239XP1W05fo!xFlWsXWh6To!iCDqtuSpM4i","dateLastActive":"2023-04-24T19:57:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":50,"score":null,"hot":3364728460,"url":"https:\/\/community.smartsheet.com\/discussion\/104384\/if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104384\/if-formula","format":"Rich","lastPost":{"discussionID":104384,"commentID":373094,"name":"Re: IF Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373094#Comment_373094","dateInserted":"2023-04-24T20:13:36+00:00","insertUserID":160809,"insertUser":{"userID":160809,"name":"Debbie Magee","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20Magee","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!239XP1W05fo!xFlWsXWh6To!iCDqtuSpM4i","dateLastActive":"2023-04-24T19:57:43+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-04-24T17:48:33+00:00","dateAnswered":"2023-04-24T17:30:59+00:00","acceptedAnswers":[{"commentID":373046,"body":"

You would=IF([DEMARC Extension Work Scheduled (Date)]@row = [DEMARC Extension Alternate Date Proposed]@row, \"Same\", \"Different\") replace<\/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":[]}">