#dependent lists

Google Sheets. Data Validation Rule now supports $$

Photo by Kaushik Panchal on Unsplash What has changed The data validation rules now have the ability to make relative links. If you copy a drop-down list with a link to a range, then the range will be changed according to the same rules as inside formulas. = $A$1 – the link does not change when copied. $ before a letter anchors the column, $ before a number anchors the string.= $A1 – when…