Teachers might prepare a set of math problems with the option to display how the problem is worked out, or a set of question with an option to display the answers.A procedure might have general steps with an option to display more detailed instructions.A schedule of events with the display of event details hidden unless a user elects to see the details.To do so, it checks for the value true which maps to Yes for users.A frequent question in Microsoft Word user forums is, "How can I create a document so that the display of certain information can be expanded or collapsed?"Īpplications for this type of document might include: The following formula checks if the Yes/No column is equal to a Yes.
The following formula checks if an email of person column is equal to a specific user's email: =if( = 'true', 'false') To do so, it uses the Date() function to convert a given string into a date: =if( = Date(''), 'true', 'false')Īn example of checking if the date column is less than or equal to a specific date: =if( = Date('') & <= Date(''), 'true', 'false') The following formula checks if the date column is equal to a specific date. The following formula checks if the number column is less than or equal to 120: =if( 500, 'true', 'false') The following formula checks if the choice column has a value Product Management: =if( = 'Product Management', 'true', 'false') Time calculations in Date and Time column.Person or Group with multiple selections.While the formula supports many of the available column types, we do not currently support the following column types: Unsupported column types in conditional formulas For example, to get the value of a field with an internal name of "ProductName", use. The column is represented by specifying the internal name of the field surrounded by square brackets and preceded by a dollar sign.
Returning true results in showing the column on the form while returning false hides the column. A formula starts with an equal sign (=) followed by the if function that returns either a true or a false result.įor example, the following formula checks if the value for the Category column is Product Management: =if( = 'Product Management', 'true', 'false') To clear the condition, leave it blank.įormulas are equations that perform conditional checks on column values in a list or library.To determine whether this column is shown or hidden, specify a conditional formula based on the value of another column.In the more options, select Edit conditional formula. Select the far right hand edge of the column name to display the options menu (.) Navigate to the desired column for which you want to set a conditional formula
To specify a conditional formula for a column, in the Edit columns pane: You can show or hide columns in a list form based on another column's value by specifying a formula that are equations performing conditional checks on values in a SharePoint list or library. Specify conditional formula to show or hide columns If you want to re-arrange the order of the columns, either drag-and-drop the column name, or first select the far right hand edge of the column name to display the options menu (.) and then select Move Up or Move Down as preferred.