|
Os tipos de arquivos clássicos não estarão mais disponíveis para uso a partir de janeiro de 2021. Você pode fazer a transição de seus arquivos clássicos ou baixar um PDF. Saber mais

Calendar/Date Selector as Data Validation option

Respondida
Solicitar demonstração

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

1

Comentários

2 comentários

Data Votos
  • 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

Por favor, entrar para comentar.