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)?

2件のコメント

Mike Davis

2020年08月21日 13:46
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
Alex Muller

2020年08月21日 14:02
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

サインインしてコメントを残してください。