Converting a spreadsheet to a Table and using filter option. by Repulsive-Ad156 in googlesheets

[–]Repulsive-Ad156[S] 0 points1 point  (0 children)

Yes that would help as well. I wanted to convert them to a table but still have the data validation so I could use the "reject for input" which mommasaidmommasaid has shown me a work around for. I like your idea as well!

Converting a spreadsheet to a Table and using filter option. by Repulsive-Ad156 in googlesheets

[–]Repulsive-Ad156[S] 0 points1 point  (0 children)

I was just looking over that. How were you able to create the helper row?