多个IF(AND)引用

method90
method90 ✭
在内容基本知识

你好,

这可能是一个简单的问题，但似乎无法找出我错在哪里。见下图。

所以，如果我的AREA CONCAT列中有VALUE 1，那么我需要它交叉引用第一个表(右下)，并运行if (and)公式来实现它之间的时间槽。

如果是VALUE 2，则需要引用表2(右下)。还有另外7个这样的表，有7个不同的值。

到目前为止，您可以看到的公式仅适用于这两个表。有没有更简单的方法来达到这个结果?在这方面的任何帮助都会有所帮助，因为这个公式适用于VALUE 1，但似乎不能让它适用于VALUE 2。我想知道是否有一种方法来注入OR函数来得到我想要的结果?

提前谢谢你。

image.png


· 在Facebook上分享 在推特上分享

答案

类别

Hello @ARE_SMC<\/a> ,<\/p>

Add a 0 in front of single digit months and it will sort correctly, ie January (01).<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":103046,"type":"question","name":"Survey Form Automation & Teams Integration","excerpt":"I've created a form for the HR Dept to collection employee appreciation submission. They want all submissions posted to the Team group. I was able to complete all the required ask except I can't figure out how to remove the link at the top because they don't want anyone to have access to the…","categoryID":321,"dateInserted":"2023-03-22T21:35:15+00:00","dateUpdated":"2023-03-23T12:07:17+00:00","dateLastComment":"2023-03-24T15:51:43+00:00","insertUserID":151846,"insertUser":{"userID":151846,"name":"Marcia562","url":"https:\/\/community.smartsheet.com\/profile\/Marcia562","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!k7lTf3TKRD0!XacpX0JyFDo!s5oPSjX47im","dateLastActive":"2023-03-26T20:45:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"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-03-27T09:06:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":56,"score":null,"hot":3359198218,"url":"https:\/\/community.smartsheet.com\/discussion\/103046\/survey-form-automation-teams-integration","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103046\/survey-form-automation-teams-integration","format":"Rich","tagIDs":[204,334,448],"lastPost":{"discussionID":103046,"commentID":368883,"name":"Re: Survey Form Automation & Teams Integration","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/368883#Comment_368883","dateInserted":"2023-03-24T15:51:43+00:00","insertUserID":91566,"insertUser":{"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-03-27T09:06:35+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/SGQGNUKUVNZE\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-24T03:39:24+00:00","dateAnswered":"2023-03-24T03:04:17+00:00","acceptedAnswers":[{"commentID":368771,"body":"

Hey @Marcia562<\/a> <\/p>

There is a work-around for the Teams post that would not include the link to the sheet. Instead of using the Alert Teams Notification, use the Alert Someone instead, then use the email address of the Teams Channel as the specific person you are sending to. Using this option you can then use Placeholders (field names enclosed in {{field name}} inserted in the message body. You could insert every field needed. Then choose Message Only . This option does not include the sheet link with the message.<\/p>

Would this work for you?<\/p>

Kelly<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":103039,"type":"question","name":"Data Shuttle and Googles Sheets that are connected by BigQuery","excerpt":"Hello all I wanted to use Data Shuttle to import data from Google sheets. This sheet has multiple tabs of which some are connected by BigQuery and some are not. When I use Data Shuttle and target the \"connected\" tabs the mapping only shows the name of the Tab itself and not the column names. But if I select a tab that is…","categoryID":343,"dateInserted":"2023-03-22T19:41:37+00:00","dateUpdated":null,"dateLastComment":"2023-03-24T12:12:34+00:00","insertUserID":140506,"insertUser":{"userID":140506,"name":"Elguapo24","url":"https:\/\/community.smartsheet.com\/profile\/Elguapo24","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pbFUaTHZtPw!m9_WH_25ZP4!gzRzebFei0D","dateLastActive":"2023-03-24T12:08:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":140506,"lastUser":{"userID":140506,"name":"Elguapo24","url":"https:\/\/community.smartsheet.com\/profile\/Elguapo24","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pbFUaTHZtPw!m9_WH_25ZP4!gzRzebFei0D","dateLastActive":"2023-03-24T12:08:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3359175251,"url":"https:\/\/community.smartsheet.com\/discussion\/103039\/data-shuttle-and-googles-sheets-that-are-connected-by-bigquery","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103039\/data-shuttle-and-googles-sheets-that-are-connected-by-bigquery","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":103039,"commentID":368802,"name":"Re: Data Shuttle and Googles Sheets that are connected by BigQuery","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/368802#Comment_368802","dateInserted":"2023-03-24T12:12:34+00:00","insertUserID":140506,"insertUser":{"userID":140506,"name":"Elguapo24","url":"https:\/\/community.smartsheet.com\/profile\/Elguapo24","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pbFUaTHZtPw!m9_WH_25ZP4!gzRzebFei0D","dateLastActive":"2023-03-24T12:08:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-24T12:24:46+00:00","dateAnswered":"2023-03-24T11:25:36+00:00","acceptedAnswers":[{"commentID":368794,"body":"

Hey @Elguapo24<\/a> <\/p>

I heard from another customer (also using BigQuery and Google Sheets) that if you set First Row = 2<\/strong> it will pull in the column names and import the data!<\/p>

Let me know if that resolved your issue.<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">