Hi,
I am trying to generate some enum lists for selecting valid meterages based on input data within the table and within another table. I have had success using the following formula in the data validity section:
โSELECT(Build data[Chainage Actual],
AND(
([Chainage Actual] >= [_THISROW].[Start chainage]),
([Chainage Actual] <= [_THISROW].[End chainage]),
([Shift Type]= 3. Supervision)
)
)โ
This obviously generates me a dropdown enumlist of valid chainage actual values and does not allow me to add any values that are invalid (even if โallow other valuesโ is enable). However I want to have the ability to add a couple of standard text values N/A and no data used for example.
I have tried a couple of methods to resolve this but havenโt had any luck with the following:
- Using LIST(my formula, โN/Aโ) to suggested values- this doesnโt separate the formula values into a drop down
- Trying to use LIST in the data validity area
Any ideas with how to combine a select function and a some text into a drop down?
LinkedIn
Twitter
