Spreadsheet: 699383d1602579478-check-the-condition-and-return-the-value-as-1-if-statement-solution_for-sol-1-
Sheet: Americas

Account Sales Region | Account Sales Country | Opportunity Owner | Opportunity Name | Opportunity External Id | Campaign Name | Account Name | Account External Id | [NAME] | Expected [NAME] | Submission Deadline | Decision Date | Start Operations Date | End Operations Date | Duration (Months) | Global Projects Industries | Reporting Currency | Total Target Revenue | Gross Profit % | Freight Tonnes | Target Revenue (current year) | Target Revenue (next year) | Target Revenue (in two years) | Commercial Support | Technical Support | Ocean Chartering Support | Engineering Support | Project Region | Project Country | Project Location Report | Created Date | Last Update Date | Opportunity ID | # of Opportunities | # of Opportunity ID | Total Target Revenue | Currency | Competitors | Result
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/INFRASTRUCTURE AU CROSS TRADE PIPES LA | WW-WWTWI-300003217633472 |  | Infrastructure Solutions Australia | WW-WWTWI-300003146842842 | Solution Design | 2020-06-24 00:00:00 | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | 2020-09-03 00:00:00 | 2020-10-28 00:00:00 | 2 | Infrastructure Industry | USD | 1200000 | 0.15 | 9000 | 1200000 | 0 | 0 | Y | N | N | N | Americas |  | Americas | 2020-06-29 00:00:00 | 2020-09-17 00:00:00 | 300003217633472 | 1 | 1 | 1200000 | USD | Agility |  |  | If the Column I has Solution Design then consider column J, K L,M, N should be in the future from the current date Else the Row has "Error"
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/INFRASTRUCTURE AU CROSS TRADE PIPES Seattle | WW-WWTWI-300003237131220 |  | Infrastructure Solutions Australia | WW-WWTWI-300003146842842 | Decision Pending | 2020-08-10 00:00:00 | 2020-08-25 00:00:00 | 2020-12-31 00:00:00 | 2020-09-23 00:00:00 | 2020-11-30 00:00:00 | 2 |  | USD | 250000 | 0.15 | 895 | 250000 | 0 | 0 | N | N | N | N |  |  |  | 2020-08-10 00:00:00 | 2020-09-17 00:00:00 | 300003237131220 | 1 | 1 | 250000 | USD | Agility
Asia/Pacific | Australia | BOMSI IRANI | GP-AU PROJECT/OLEX NEXAN CABLES AU MOLOGIA VALLEY | WW-WWTWI-300003237365507 |  | OLEX AUSTRALIA PTY LIMITED | AU-SAP331-D0002760531 | Decision Pending | 2020-08-12 00:00:00 | 2020-08-12 00:00:00 | 2020-10-28 00:00:00 | 2020-11-26 00:00:00 |  |  |  | USD | 1177284 |  | 56 | 1177284 | 0 | 0 | N | N | N | N |  |  |  | 2020-08-11 00:00:00 | 2020-09-14 00:00:00 | 300003237365507 | 1 | 1 | 986000 | EUR | KUEHNE & NAGEL
Asia/Pacific | Australia | BOMSI IRANI | GP-AU-PROJECT/CRRC AUSTRALIA HCMT REPAIR TRAIN | WW-WWTWI-300003186604334 |  | CRRC CHANGCHUN AUSTRALIA P/L | AU-SAP331-D0002680430 | Decision Pending | 2020-05-01 00:00:00 | 2020-05-01 00:00:00 | 2020-12-31 00:00:00 | 2020-12-22 00:00:00 | 2021-12-02 00:00:00 | 12 | Infrastructure Industry | USD | 417900 | 0.15 | 271200 | 417900 | 0 | 0 | N | N | N | N | Asia/Pacific | Australia | Australia | 2020-05-01 00:00:00 | 2020-09-17 00:00:00 | 300003186604334 | 1 | 1 | 350000 | EUR | GEODIS |  |  | If the Column I has Decision pending then Consider Column J in the past and the rest K,L,M,N should be in the future else the row has "Error" If there is no error show as  "0"