gavindavey
New Member
- Joined
- Feb 19, 2016
- Messages
- 9
Hi
I am trying to do a data validation list where only the on the form below where if I mark a one in any of the columns in blue I only get these result from my data validation list rather than them all.
So if I have a 1 in Type Specific and Land Reg columns then on the same row under Errors I would only be able to select form these two list. My data validation list is below.
<tbody>
</tbody>
<tbody>
</tbody>
I am trying to do a data validation list where only the on the form below where if I mark a one in any of the columns in blue I only get these result from my data validation list rather than them all.
So if I have a 1 in Type Specific and Land Reg columns then on the same row under Errors I would only be able to select form these two list. My data validation list is below.
| Fundamental | Building Details | Type Specific | Listing Details | Image | Deals | Contacts | Land Reg / RoS | Rates | Error 1 | Error 2 | Error 3 | Error 4 | Error 5 | Error 6 | Error 7 |
| 1 | 1 |
<tbody>
</tbody>
| Overview - Missing / Incorrect - NIA |
| Overview - Missing / Incorrect - TFS |
| Overview - Missing / Incorrect - RBA Breakup |
| Overview - Missing / Incorrect - YOC |
| Overview - Missing / Incorrect - Construction Type |
| Overview - Missing / Incorrect - Secondary Type |
| Overview - Missing / Incorrect - Car Parking |
| Overview - Missing / Incorrect - Site Size |
| Overview - Missing / Incorrect - Sprinkler type |
| Overview - Missing / Incorrect - Footprint |
| Building Note - Missing |
| Building Note - Spelling or Grammar |
| Type Specific - Missing / Incorrect Loading docks |
| Type Specific - Missing / Incorrect Clear Height |
| Type Specific - Missing / Incorrect Owner Occupied/Tenancy |
| Type Specific - Missing / Incorrect LEED Certification |
| Type Specific - Missing / Incorrect BREEAM |
| Type Specific - Missing / Incorrect Elevators |
| Type Specific - Missing / Incorrect Features |
| Type Specific - Missing / Incorrect Frontage |
| Type Specific - Missing / Incorrect Floor |
| Type Specific - Missing / Incorrect Columns |
| Type Specific - Missing / Incorrect Truck Wells |
| Type Specific - Missing / Incorrect Utilities |
| Type Specific - Missing / Incorrect Rail Line |
| Type Specific - Missing / Incorrect Crane Service |
| Type Specific - Missing / Incorrect Power |
| Listing Details - Missing / Incorrect s - Missing / Incorrect Space Use |
| Listing Details - Missing / Incorrect - Missing / Incorrect Size |
| Listing Details - Missing / Incorrect Marketing Address |
| Listing Details - Missing / Incorrect Rent |
| Listing Details - Missing / Incorrect Service |
| Listing Details - Missing / Incorrect Service Charge |
| Listing Details - Missing / Incorrect Condition |
| Listing Details - Missing / Incorrect Build Out |
| Listing Details - Missing / Incorrect Space Breakdown |
| Listing Details - Missing / Incorrect Vacancy Date |
| Listing Details - Missing / Incorrect Vacating Tenant |
| Listing Details - Missing / Incorrect Term |
| Listing Details - Missing / Incorrect Rent Reviews |
| Listing Details - Missing / Incorrect Loading Docks |
| Listing Details - Missing / Incorrect Listing Agents Details |
| Listing Details - Missing / Incorrect Images |
| Listing Details - Missing / Incorrect Goad |
| Listing Details - Missing / Incorrect PDF |
| Listing Details - Missing / Incorrect Under Offer |
| Space Note - Spelling or Grammar |
| Listing Details - Missing / Incorrect Features |
| Listing Details - Missing / Incorrect |
| Deals - Missing Info |
| Deals - Missing |
| Deals - Incorrect Info |
| Land Reg Date |
| Land Reg - Missing Owner |
| Land Reg - Incorrect Owner |
| Image - Missing |
| Image - Incorrect |
<tbody>
</tbody>
