Data Validation Formulas
| Only allow a certain number of characters | Data Validation - Only allow |
| Only allow characters in uppercase | Data Validation - Only allow |
| Only allow dates | Data Validation - Only allow |
| Only allow dates in a particular range | Data Validation - Only allow |
| Only allow dates in a particular year | Data Validation - Only allow |
| Only allow dates in the current year | Data Validation - Only allow |
| Only allow dates in the next 30 days | Data Validation - Only allow |
| Only allow dates that are weekdays | Data Validation - Only allow |
| Only allow dates that are weekends | Data Validation - Only allow |
| Only allow entries in a particular format | Data Validation - Only allow |
| Only allow numbers | Data Validation - Only allow |
| Only allow numbers in a particular range | Data Validation - Only allow |
| Only allow numbers that are whole numbers | Data Validation - Only allow |
| Only allow percentages | Data Validation - Only allow |
| Only allow percentages that are whole numbers | Data Validation - Only allow |
| Only allow text | Data Validation - Only allow |
| Only allow text in uppercase | Data Validation - Only allow |
| Only allow times | Data Validation - Only allow |
| Only allow unique values no duplicates | Data Validation - Only allow |
| Only allow values from a predefined list | Data Validation - Only allow |
| Only allow values that are not in a predefined list | Data Validation - Only allow |
| Only allow values whose sum is restricted | Data Validation - Only allow |
| Only allow yes or no | Data Validation - Only allow |
| Only allow a certain number of characters Data Validation - Only allow |
| Only allow characters in uppercase Data Validation - Only allow |
| Only allow dates Data Validation - Only allow |
| Only allow dates in a particular range Data Validation - Only allow |
| Only allow dates in a particular year Data Validation - Only allow |
| Only allow dates in the current year Data Validation - Only allow |
| Only allow dates in the next 30 days Data Validation - Only allow |
| Only allow dates that are weekdays Data Validation - Only allow |
| Only allow dates that are weekends Data Validation - Only allow |
| Only allow entries in a particular format Data Validation - Only allow |
| Only allow numbers Data Validation - Only allow |
| Only allow numbers in a particular range Data Validation - Only allow |
| Only allow numbers that are whole numbers Data Validation - Only allow |
| Only allow percentages Data Validation - Only allow |
| Only allow percentages that are whole numbers Data Validation - Only allow |
| Only allow text Data Validation - Only allow |
| Only allow text in uppercase Data Validation - Only allow |
| Only allow times Data Validation - Only allow |
| Only allow unique values no duplicates Data Validation - Only allow |
| Only allow values from a predefined list Data Validation - Only allow |
| Only allow values that are not in a predefined list Data Validation - Only allow |
| Only allow values whose sum is restricted Data Validation - Only allow |
| Only allow yes or no Data Validation - Only allow |
Only allow dates that are weekdays |
| ?? |
| * Data Validation - Only Weekdays |
Only allow entries in a particular format |
| ?? |
| * Data Validation - Particular Format |
Only allow numbers |
| ?? |
| * Data Validation - Only Numbers |
Only allow numbers in a particular range |
| ?? |
| * Data Validation - Particular Range |
Only allow percentages |
| ?? |
| * Data Validation - Percentages |
Only allow text |
| ?? |
| * Data Validation - Only Text |
Only allow text in uppercase |
| ?? |
| * Data Validation - Particular Format |
Only allow times |
| ?? |
| * Data Validation - Time Range |
Only allow unique values no duplicates |
| ?? |
| * Data Validation - Prevent Duplicates |
Only allow values from a predefined list |
| ?? |
| * Data Validation - Prevent Duplicates |
Only allow values whose sum is restricted |
| ?? |
| * Data Validation - Restrict The Total |
Only allow yes or no |
| ?? |
| * Data Validation - Yes No Drop-Down |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top