While the other two answers here are correct in that it is fairly straightforward to hide the fields conditionally based on the Title value, what I think is going to be more of a problem for you is that you say that when all 6 fields are shown, they are all required.
This presents a problem, because if you make them required fields in the list, if you hide ...
As we know that PeoplePicker columns cannot be used in List Validation settings, So I don't think there is any OOTB option to achieve this requirement.
So, what is workaround?
Here I am sharing possible workaround, I haven't tried this requirement, but based on my work on PeoplePicker and customization of default Lists Item Adding form I am sharing the ...
You can try to add the field of "Number" type field and make the following settings.
Field Type - Number
Column settings: You can specify a minimum and maximum allowed value (Minimum -0 and Maximum-7)
It will do the out of box validation and throughs error if the number is not in the range.
You can only have one formula. You have to combine the two formulas so that combined they return a true or false.
=AND( firstCondition, secondCondition )
Both must return true for the AND to return true.
=AND( IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE),
IF(Status="Paid",IF([Customer Paid Date ]<>"",TRUE,FALSE),TRUE) ...
Columns are"blank" rather than NULL. Try this in a Calculated Column if you want to display the message in another column.
. =IF( ISBLANK( [yourColumn] ), "n/a", "")
If the column is a Single line of Text column, then you could set the default to "n/a".
You can add a validation if you want to prevent the save when blank.
If its just a Name and Decision field, I'd suggest making both Name and Decision mandatory fields. You can do this by going to Library Settings > [Your Column] > Toggle the radio button to "Make field mandatory" > Save. This'll make it required to have all the "Mandatory" fields required to be filled out.
If there's a use case for your list where you wouldn'...
I think you should take a look at the validation functions for SharePoint. It's very similar to Excel.
A reference for Validation expressions
A couple things to keep in mind:
Validation equations must return True or False
Column validations can't refer to other columns (in this case you'll need to do a List validation, not column validation)
So we'll ...
You need to set the formula value to TRUE in case user selects the "No-Copy". So, try using below formula:
Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).
From my understanding you have four columns StartDate1, StartDate2, EndDate1, and EndDate2. I'll shorten these to S1, S2, E1, and E2respectively. The final equation will use the full names at the bottom of the post. If the validation doesn't work, please let me know.
To put list validation on, you have to go to List Settings > Validation Settings as per ...
I don't know all your requirements. But I guess you want "Billing Status" field to be mandatory if "A La Carte" is equal to "Yes"(Correct me if I am wrong).
In this case you need to use below formula:
IF([A La Carte]="Yes",NOT(ISBLANK([Billing Status])),TRUE)
We can use jQuery code to achieve it.
I create a custom list with the choice columns "Master vs Copy" and "Duplicate Rationale".
Then add the code below into script editor web part in the newform.aspx page.
Unfortunately, the Validation Setting formula is only applied to specific fields on the same ROW.
Check The Supported and Unsupported Columns In SharePoint Calculated
Therefore, you can't search for column values and validate against these values in the SharePoint validation setting or calculated field like Excel formula!
If you are using list validation, which works in both classic and modern experience on SharePoint Online, then this is the formula you want:
=AND(AND([Date Closed]>=[O365 Queue],[Date Closed]>=[Start Date]),[Date Closed]>=[Create Date])
Make sure to provide users a clear message on why the validation fails, something like:
The 'Date Closed' ...
Same column default calculated values wont work as the formula can not circular reference the column which contains it.
However, this can be achieved a number of ways, depending if you simply wish to display the N/A for cosmetic purposes in the UI, or if you actually require the underlying value to be set.
For display only :-
Client Side Rendering (CSR) ...
Just add ISBLANK to your formula like this:
=IF(ISBLANK([MAC Address]),6,(LEN([MAC Address])=17) +(MID([MAC Address],3,1)=":") +(MID([MAC Address],6,1)=":") +(MID([MAC Address],9,1)=":") +(MID([MAC Address],12,1)=":") +(MID([MAC Address],15,1)=":"))=6
=OR(ISBLANK([MAC Address]),AND(LEN([MAC Address])=17,MID([MAC Address],3,1)=":",MID([MAC Address],...
Use OR to combine the two formulas.
You can try that:
=OR(IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE), IF(Status="Paid",IF([Customer Paid Date ]<>"",TRUE,FALSE),TRUE))
If it doesn't work, you can also use your formula:
=IF(Status="Invoiced",IF([Customer Invoiced Date]<>"",TRUE,FALSE),TRUE)
Refer below formula -->
=IF([Job Type]="Call",IF(OR([Agent]<>"",[H2H Partner]<>""),TRUE,FALSE),TRUE)
Here, if Job Type equals to Call then only it will check Agent and H2H Partner fields for nonblank values.
Otherwise if Job Type is not equal to Call then it will directly return TRUE. That means it will allow blank values for these two fields.
Write a function to hide/show fields you wanted by passing value of Title field. Hide fields on empty or matches to myTitle5, and myTitle6
Call this function on a page load.
Attach a blur event to the Title field and call the above reusable function.
The above steps works for New Form and Edit form.
Let me know which ...
then hide/show the other fields accordingly
The Show/Hide part has been asked and answered many times before here on SO, use the search