Calendar/Date Selector as Data Validation option
답변함Is there a way to either use Data Validation or Conditional Formatting in a spreadsheet to have the end user select a date (like from a calendar)?
-
Hi Scott!
Thanks for the question, and sorry for the delay in getting to this. There is currently not a calendar/date selector as a Data Validations option. As a workaround, you could build a repository of the dates available and have that be your reference for the your Data Validation. Something like this:
Data Validation of 2020 Calendar Dates
Data Validation Choices
This functionality is being looked at by our Product Team, so I'm happy to pass along your interest. In the meantime, holler if you have any questions or need anything. Happy Friday!
1
Thank you for the referral Mike Davis. While this is a workaround, the previous classic version is obviously a lot more practical and involves less much less scrolling. Let's hope the previous data validation methods make their way into next-gen spreadsheets.
-1댓글을 남기려면 로그인하세요.
댓글
댓글 2개