If you add an invalid date in a cell, spreadsheets let you move forward. In an email column if you enter an invalid email ID - it does not warn you and you live with this error forever. Add a special character before your number and you might get a warning with suggestions to convert the cell value to numbers or text. But you are free to ignore the warning and move forward.
Now imagine a bit more. You are working on a sheet that has age, date and country columns. If I share this sheet with 3 different team members and ask them to add their data based on existing date range, age range and country list – how would I achieve this without setting validation criteria?
If some of these points were addressed in spreadsheets without efforts, I doubt online forms would be in any demand for collecting validated data.
We are rethinking the best way to work and manage our data lists with a spreadsheet-like experience. Will love to have your thoughts on how you do all of these today. Spreadsheets or online forms….?
Founder, CollateBox Inc.