Error validating the formula for column
Use lookups or maximum and minimum values to validate user entries.
For more complex validations you can write a formula to check the entry.
For example, if you define an element name in Chinese, the base element name is stored in Chinese.
The database Items are generated using the data in the base tables, so the generated DBI contains the Chinese element name, and you can refer to such DBI's in your formulas.
Each formula usage summarized in this topic corresponds to one or more formula types, requiring specific formula inputs and outputs.
One of the great new features that end-users love in Share Point 2010 is the ability to validate input.
It provides an easy way to make sure that users enter the correct type of data in a metadata field.
Excel tables A very useful feature in Excel is defined tables, introduced in Excel 2007.
Earlier versions had this feature as well but it was then known as Excel Lists. It will simplify your […]Comments(0) Filed in category: Built-in features, Excel, Excel table INDIRECT function INDIRECT(ref_text,a1) Arguments Ref_text is a reference to a cell that contains an A1-style reference, an R1C1-style reference, a name defined as a reference, or a reference to a cell as a text string.
a1 specifies the type of reference in argument ref_text.