regexgoogle-sheetsgoogle-sheets-formulags-conditional-formattingtextjoin
Conditional Formatting in merged cell
guys, I'm trying to do some crazy things in Google Sheets and I'm getting in trouble. Can someone help me? I have this sheet with tasks and subtasks. Each subtask has a status (done, in progress or not stated)What I want to do is set one progress for task depending on its subtasks. This way:
- if all subtasks have a status not stated, the task is not stated(red color)
- if all subtasks have a status done, the task is done(green color)
- if all subtasks have a status in progress, the task is in progress (orange color)
- if we have at least one subtasks not stated, the task is not stated. Same for another status
Solution
try separately for A column with those merged cells:
=REGEXMATCH(TEXTJOIN(" ", 1, C:C), "Not Started")*(B:B<>"")
=REGEXMATCH(TEXTJOIN(" ", 1, C:C), "In Progress")*(B:B<>"")
=REGEXMATCH(TEXTJOIN(" ", 1, C:C), "Done")*(B:B<>"")
- JS Regex MatchAll with combination of Comma & Semicolon
- Symfony Routing Host Regular Expression
- Regular Expression to parse Common Name from Distinguished Name
- Add a value and sum it up using Notepad++
- Regex for Number "05XXXXXXXX"
- Replace one character but not two in a string
- how to escape hyphen in regex character group in c
- Why do some regex engines match .* twice in a single input string?
- What do 'lazy' and 'greedy' mean in the context of regular expressions?
- How to test if a RegExp contains capturing groups in its definition?
- create regex to match format of 00:00:00 for duration (not time)
- regex for expression with one separator hyphen
- Remove special character and units form Pandas column name with Python
- Replace variables in a formula with their definitions
- RegEx to differentiate chemical compound names from pattern
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- open vimeo url in colorbox using jQuery filter
- Split address and numbers
- Pyspark Regular Expression add double quotes after comma
- In the regex world what's a flavor and which flavor does Java use?
- Problems with table extraction using pdfplumber - empty fields in large tables
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Using setCustomValidity stops input from validating