I'm hoping you can help. I need to add data validation to our app based upon two fields. SpanID and JobID.
A JOBId is created for a SPANId (a location basically).
JOBID is always unique and I have a data validation formula that prevents duplicate entries successfully.
We have another column in the sheet - IsPassed. This is a true/false that shows a JOBId has been through the whole work process and has been passed/closed.
Jobs can also be removed from the programme via a REMOVED column (true/false). the records are still retained in the database though.
I'm trying to allow the addition of a duplicate SpanId only where the following is true for records that already exist:
REMOVED = False AND IsPassed=True
OR
Removed=True
Any assistance welcome as so far I've drawn a blank with formulas I've tried.
Thanks
LinkedIn
Twitter
