In my list I have 3 columns, one titled 'Review Status', one titled 'Type of System' and one titled 'Needed Information'.
I am trying to write a validation that says
If the Review Status equals Permit Issued AND the Type of System is Null/Blank then display the error message.
If the Review Status equals 'Additional Information Required' and the 'Needed Information' field is Null/Blank then display the error message.
We don't want to allow the permit to be issued if staff doesn't enter the type of system. And we don't want staff to sign off the reiew as 'Additional Information Required' if they don't tell us what additional information is required. Can someone please help me with the Formula? I have tried quite a few different ways.