i am using sharepoint 2010. I have a list where I use validation for my columns.
I want to hide field "Contract Extension Reason" when Type of Contract is equal to "Contract Extension"
I tried this but it says, "The formula contains a syntax error or is not supported."
=IF([Type of Contract]<>"Contract Extension"...
I Suggest you split the documents into a new view to reduced to less than 5000.
In addition,display 12 or more columns of the following types can cause a list view threshold error: people, lookup, and managed metadata, display columns of other types will not.
I found the solution
To NewForm I added this script to Script Editor Web Part
You can do this with Column Formatting directly on the PromotedState column using this format:
"txtContent": "=if(@currentField == 0, 'Sitepage', if(@currentField == 2, 'Newspage', ''))"
The double check is there to account for folders.
You can apply this format by adding the Promoted State ...
You could use a 'count related' lookup column to get close to what you need
to do this, you'll need to split in to two lists: one called 'devices' and on called 'reservations'
Now, create a lookup from reservations to device, so that when you make a reservation you can select a device.
Next, make a lookup from the device list to the reservations list. Make ...