Data validation: Specific value only possible if other Columns filled

%3CLINGO-SUB%20id%3D%22lingo-sub-2545749%22%20slang%3D%22en-US%22%3EData%20validation%3A%20Specific%20value%20only%20possible%20if%20other%20Columns%20filled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2545749%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%20-%20Robot%20status%20should%20only%20be%20possible%20to%20be%20saved%20if%20KOB%2C%20RATING%20and%20ERP%20is%20filled%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mEVHCnc%22%20style%3D%22width%3A%20540px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295667i3690644DFFDF1B20%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22mEVHCnc%22%20alt%3D%22mEVHCnc%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20this%20through%20data%20validation%20or%20is%20there%20a%20better%20way%20to%20do%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CIMG%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2545749%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Dear Community,

 

OK - Robot status should only be possible to be saved if KOB, RATING and ERP is filled out.

 

mEVHCnc

 

How can I do this through data validation or is there a better way to do it?

Ive created a helper column called Filled: =IF(OR(ERP="";KOB="";RATING="");FALSE;TRUE)

But I dont know if its possible to restrict one status only to be possible if this helper column is "True"

 

0 Replies