IF下发目标函数
如何构建一个包含两个变量的公式来提供目标日期?
例如:如果单元格A =定义变量，单元格B =定义变量，那么单元格D =从单元格c中反映的日期起6个月。我可以使用IF和Edate函数在excel中做到这一点，但无法在Smartsheet中弄清楚。如能提供任何帮助，将不胜感激。
评论
-
她名叫Stara ✭✭✭✭✭✭嗨,马特,
试试这个。
=如果(和((电子邮件保护)=“价值”;(电子邮件保护)= "值");(电子邮件保护)+ 180)
相同的版本，但有以下更改，以方便您和其他人。
=如果(和((电子邮件保护)=“价值”,(电子邮件保护)=“价值”),(电子邮件保护)+ 180)
根据国家的不同，你需要把逗号换成句号，把分号换成逗号。
奏效了吗?
祝你度过美好的一天!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
类别
=INDEX({Data SHPType}, MATCH(Course@row, {Data Course}, 0<\/strong>))<\/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":106453,"type":"question","name":"Row Status Indicator in Schedule","excerpt":"Wrote a formula to check two items and change and indicator light. Here is the code but it is saying incorrect argument set? =IF(Status@row <> \"Complete\", [Due Date]@row < TODAY(), \"Red\", IF(Status@row <> \"Complete\", [Due Date]@row >= TODAY(2), \"Yellow\", \"Green\")) I have reviewed everything multiple times and cannot figure…","categoryID":322,"dateInserted":"2023-06-14T19:15:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T10:03:13+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:59:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-15T11:40:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":17,"score":null,"hot":3373594721,"url":"https:\/\/community.smartsheet.com\/discussion\/106453\/row-status-indicator-in-schedule","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106453\/row-status-indicator-in-schedule","format":"Rich","lastPost":{"discussionID":106453,"commentID":380712,"name":"Re: Row Status Indicator in Schedule","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380712#Comment_380712","dateInserted":"2023-06-15T10:03:13+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-15T11:40:05+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"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-06-15T10:03:03+00:00","dateAnswered":"2023-06-14T22:55:59+00:00","acceptedAnswers":[{"commentID":380684,"body":" I figured out the code and here it is in case anyone is trying to do the same thing<\/p> =IF(AND([Due Date]@row < TODAY(), Status@row <> \"Complete\"), \"Red\", IF(AND([Due Date]@row = TODAY(2), Status@row <> \"Complete\"), \"Yellow\", \"Green\"))<\/p> Caroline<\/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":106475,"type":"question","name":"Applying a formula for the whole column","excerpt":"Hi! I currently have a formula for a specific cell in a row. I would like to apply that formula to all cells in the same column. I tried dragging the formula down as far as I can go, but when a new row is added from a form, it seems to add way down my sheet (not consecutively after the last entry) and the formula is not…","categoryID":322,"dateInserted":"2023-06-14T21:59:50+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T22:46:53+00:00","insertUserID":123105,"insertUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":123105,"lastUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3373564003,"url":"https:\/\/community.smartsheet.com\/discussion\/106475\/applying-a-formula-for-the-whole-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106475\/applying-a-formula-for-the-whole-column","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":106475,"commentID":380683,"name":"Re: Applying a formula for the whole column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380683#Comment_380683","dateInserted":"2023-06-14T22:46:53+00:00","insertUserID":123105,"insertUser":{"userID":123105,"name":"Thu Nghiem","url":"https:\/\/community.smartsheet.com\/profile\/Thu%20Nghiem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T22:37:22+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-06-15T10:29:40+00:00","dateAnswered":"2023-06-14T22:05:26+00:00","acceptedAnswers":[{"commentID":380679,"body":" Hi there.<\/p> All you have to do is right click on a cell where you have the formula and click on \"Convert to Column Formula\".<\/p>
<\/p>
![\"Column](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/Z9B9OAJOBFOE\/column-formula.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
