Google Sheets: Add a clickable calendar in cells (data validiation by valid date)
Автор: DoIT Training at Stony Brook University
Загружено: 2019-09-16
Просмотров: 11864
Описание:
Help ensure better data in your Google Sheet by adding a clickable calendar for entering dates. Then set the date formatting you want for the cells to ensure consistent date data. [Follow along with copy of demo sheet and slides below]
1) Select the range you want the calendar in
3) Data, Data Validation
4) Criteria: date; is valid date
5) Select the range; format,
Copy Demo Sheet: https://doittraining.page.link/better...
Slides: https://docs.google.com/presentation/...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: