Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Calendar/Date Selector as Data Validation option

Answered
Request Demo

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

0

Comments

2 comments

Date Votes
  • Mike Davis

    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

    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

Please sign in to leave a comment.