Spreadsheet: 118293d1313591354-find-string-text-in-complex-in-formula-test
Sheet: touchstone

Description | Work Type | Work Status | Work Cost Center | Authorizations | Milestone Flag | Milestone Relevant for Management? | Schedule Duration | [NAME] | Schedule Finish | Actual Start | Actual Finish | Actual/Schedule Start | Actual/Schedule Finish | [NAME] | Baseline Finish | Milestone Status | Milestone % completed
Project: 0006515 Touchstone Control Programme (Reporting) | Project | Open/Approved |  | 5 | No | No | 165.0d | 01/04/2011 | 18/11/2011 | 02/01/2006 |  | 02/01/2006 | 18/11/2011 | 02/01/2006 | 30/11/2009 | Green | 0
Phase: Project Duration | Project | Open/Approved |  | 0 | No | No | 1.0d | 30/05/2011 | 30/05/2011 | 02/01/2006 |  | 02/01/2006 | 30/05/2011 | 02/01/2006 | 30/11/2009 | Green | 80
Phase: 1. Conceptualization | Project | Open/Approved |  | 0 | No | No | 3.0d | 18/07/2011 | 20/07/2011 | 02/01/2006 |  | 02/01/2006 | 20/07/2011 |  |  | Green | 100
Funding Approval |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-12-01 00:00:00
Phase: 2. Initiation | Project | Open/Approved |  | 0 | No | No | 1.0d | 04/04/2011 | 04/04/2011 |  |  | 04/04/2011 | 04/04/2011 |  |  | Green | 100
Phase: 3. Analysis & Design | Project | Open/Approved |  | 0 | No | No | 1.0d | 04/04/2011 | 04/04/2011 |  |  | 04/04/2011 | 04/04/2011 |  |  | Green | 100
Phase: 4. Development | Project | [NAME] |  | 0 | No | No | 0.0d |  |  | 05/07/2010 | 06/12/2010 | 05/07/2010 | 06/12/2010 |  |  | Green | 100
> Operational MI Release 12 | Project | [NAME] |  | 0 | No | No | 0.0d |  |  | 05/07/2010 | 06/12/2010 | 05/07/2010 | 06/12/2010 |  |  | Green | 100
Phase: 5. Testing | Project | Open/Approved |  | 0 | No | No | 0.0d |  |  |  |  |  |  |  |  | Green | 0
Phase: 5. Testing | Project | Open/Approved |  | 0 | No | No | 22.0d | 04/04/2011 | 03/05/2011 |  |  | 04/04/2011 | 03/05/2011 |  |  | Green | 0
> Operational MI Release 12 (PV0018849) System Test | Project | Open/Approved |  | 0 | No | No | 15.0d | 04/04/2011 | 22/04/2011 |  |  | 04/04/2011 | 22/04/2011 |  |  | Green | 100
> Operational MI Release 12 (PV0018849) UAT | Project | Open/Approved |  | 0 | No | No | 22.0d | 04/04/2011 | 03/05/2011 |  |  | 04/04/2011 | 03/05/2011 |  |  | Green | 100
Phase: 6. Implementation | Project | Open/Approved |  | 0 | No | No | 165.0d | 01/04/2011 | 18/11/2011 | 15/01/2010 |  | 15/01/2010 | 18/11/2011 |  |  | Green | 0
> Development Release 7.1 | Project | [NAME] |  | 0 | Yes | Yes | 0.0d |  |  | 15/01/2010 | 15/01/2010 | 15/01/2010 | 15/01/2010 |  |  | Green | 100
> Operational MI Release 12 (PV0018849) | Project | Open/Approved |  | 0 | Yes | Yes | 0.0d | 01/04/2011 | 01/04/2011 |  |  | 01/04/2011 | 01/04/2011 |  |  | Green | 100
> Business Rollout | Project | Open/Approved |  | 0 | No | No | 165.0d | 04/04/2011 | 18/11/2011 |  |  | 04/04/2011 | 18/11/2011 |  |  | Green | 0
Phase: 7. Post Implementation | Project | Open/Approved |  | 0 | No | No | 65.0d | 27/05/2011 | 25/08/2011 |  |  | 27/05/2011 | 25/08/2011 | 30/11/2009 | 30/11/2009 | Green | 0
> Post Implementation Reviews / Activities | Project | Open/Approved |  | 0 | No | No | 65.0d | 27/05/2011 | 25/08/2011 |  |  | 27/05/2011 | 25/08/2011 |  |  | Green | 0
> Project Close Out | Project | Open/Approved |  | 0 | Yes | Yes | 0.0d | 25/08/2011 | 25/08/2011 |  |  | 25/08/2011 | 25/08/2011 | 30/11/2009 | 30/11/2009 | Yellow | 0
Funding Approval | correct
Funding Approval Complete | incorrect |  |  | if the cell A5 has Funding Approval complete in it rather than the correct workding, I would need my formulas to still pick out the Funding Approval string and give the date. Currently if the text does not match 100% then an error is given back.