That is because we want to drag the cell formula downwards. Example: The above trick only hides the field from the entry/edit form. If they select 2, they can only select C or D, etc. Click, Once the formula for the field has been set, you will notice that it becomes grayed out, When the user tries to tag the document, the Expiration Date (the field where I pasted the conditional formula in), The field you are doing validation against needs to have a, The field you are doing validation against needs to be enclosed in square brackets. From creating simple but intuitive intranet portals to developing project management team sites and document management systems, I develop SharePoint solutions that help you get things done quickly and accurately. And only streets for the selected city will be shown. Select Get choices from an external data source and then from the data source drop-down choose Supply Chain Scorecard Section. Has the construction team of the Northrop Grumann B-2 Spirit made use of the features of the German Horten Ho 229? Note: Dollar signs ($) are used in the formula so that we can drag the cell downwards from David to Peter. Ok, all content is provided. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list. Posted on September 14, 2020 | Step by Step Instructions. In a nutshell you create a new data source pulling from the room list, then add a filter on the Room drop down to only show items from the room list with the same site as that in the Site drop down. Sharepoint 2013 List: Conditional dropdown based on another column, What I learned from hiring hundreds of engineers can help you land your next…, Hot Meta Posts: Allow for removal by moderators, and thoughts about future…, Goodbye, Prettify. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. If no one has used column formatting on the column you selected, the pane will look like the following. and set the choices for Column B to the data set with the filter on columnAValue.