У нас вы можете посмотреть бесплатно Conditional Dropdowns in Google Sheets или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
GET THE PROJECT MANAGEMENT TEMPLATE AT http://www.jpmueller.com "How can you have a spreadsheet cell give you only choices to select based on what's been selected in another cell?" In other words, Conditional, or Dependent Dropdowns. I have heard this ask over and over again for many years and I've seen many solutions that were quite limited in terms of needing to add things like range names, or only works for one row, or doesn't consider if you change the parent, or first dropdown, etc. So I finally decided it's time to take it on in Google Sheets, and solve it in an elegant and flexible way. In this video, I'll show you an example of the final solution as well as walk you through the logic that the Appscript uses to determine whether it needs to add or remove data validation rules.