New answers tagged validation
I've tried as many variations of slash / as I can come up with: \2F \002F %2F F; 0x2F ...and more We simply cannot use these characters in site column names if want to use them in this kind of custom validation.
Thank you for your input. It helped me get what I want done with the part which was missing. Adding the code here. =IF(AND(ISBLANK([Level 1 data incident (No)]),[Level 1 data incident]="No"),FALSE,IF(AND(ISBLANK([Level 1 data incident (Yes)]),[Level 1 data incident]="Yes"),FALSE,IF(AND(NOT(ISBLANK([Level 1 data incident (Yes)])),NOT(ISBLANK([Level 1 data ...
The following should require the user to EITHER select Yes and fill out "Level 1 data incident (Yes)" OR select No and fill out "Level 1 data incident (No)." It also will not validate if the user fills out BOTH the "Level 1 data incident (Yes)" AND the "Level 1 data incident (No)" fields. =AND(OR(AND([Level 1 data incident]="Yes",NOT(ISBLANK([Level 1 data ...
Yes, I think the first sentence there is inaccurate. Later in the answer he says: If required doesn't cut it, just add a validation to the checkbox, so it needs to be true. which logically makes sense: even though you are setting the checkbox to be "required" and have your validation as "cannot be blank", either state of the checkbox (checked or ...
You want to test The Project name is not blank AND The Contract name is not blank The Formula: =AND( NOT( ISBLANK([Project name]) ) , NOT( ISBLANK([Contractor name]) ) )
Top 50 recent answers are included