regexvalidationgoogle-sheetsgoogle-sheets-formulags-conditional-formatting
How to make a data validation to accept only whole number if next cell contains certain text
I have a table like this :
When I select a product with data validation in column B I get automatically the unit in column F
For example I type Product 1 in B3, and in F3 I get "Kilo" , if its product 2 I get "Piece"
What im trying to do is: If F3 <> Kilo (meaning is piece, box etc), in D3 to allow only whole numbers, but if F3 = "Kilo" then allow decimal numbers as well
And I need this to apply for the entire column
Also im tryng to format column D based on F
if F3 = Kilo then have a format like "#.##"
But if F3 <> Kilo to have only the format as "##" without decimals, only 1,3,7, 15, 30 etc
I have been looking for a solution but I don't get it
Any help please ?
Solution
try:
=((F2="pz")*(NOT(REGEXMATCH(""&D2, "\.|,"))))+(F2<>"pz")
- How to combine all the words of a sentence extracted with a regex?
- How can I detect all symbols on mathematical operators on PHP using regex?
- RegEx for combining "match everything" and "negative lookahead"
- How to validate an Instagram username
- Parse video id and start time from differently formatted youtube URL strings
- Python - regex to grab specific lines from text
- how to escape texts for formatting in python
- Regex not correctly rejecting invalid music note values
- regex - error with result - too many occurence
- Parse a formatted, single-line string into an array of associative arrays with predefined column names
- How to split a string by any of multiple delimiters?
- std::regex escape special characters for use in regex
- Does lookbehind work in sed?
- Regex for complex delimited string with multiple parse patterns
- Parsing PDF tables into csv with php
- RegEx for "does not begin with"
- PHP regex starting and ending with < and > produces an unknown modifier warning
- Sanitize number by removing first digit then any consecutive zeros
- How to match one or more characters nominated in a regex character class?
- Sanitize a number which may include dollar symbols, hyphens and dots
- Validate a numeric filename which may only be between 01 and 12, then the file extension
- Regex for number check below a value (12)
- Validate a string containing a number, underscore, then an number with a maximum of 12 digits
- Regular expression that allows only a specific special character when it has a specific length
- java - regex pattern matching days, hours, minutes, seconds
- Regex pattern for matching words between two delimiters
- Matching a String in Python using regex
- How to match and extract string matching regular expression
- Problem subsetting a string from a filename
- Remove all non-alphanumeric characters but keep float values