User profile for user: HayleyHatzi
HayleyHatzi Author
User level: Level 1
7 points

Numbers formula showing a message when there are no 'TBA' cells

Hi there. I have a formula that triggers a message "ORANGE CELL = CLEINT TO PROVIDE MISSING INFORMATION". This alerts my client I need information, but is not there when there are no cells that state "TBA". It has been working a treat, however today I have noticed the prompt is still showing even through there are no cells stating "TBA". What is wrong with my formula? Apologies for not including the entire sheet in my screenshot....just trying to protect my client.





[Re-Titled by Moderator]

Original Title: Numbers Formula

iMac (2017 – 2020)

Posted on Nov 17, 2025 1:54 PM

Reply
Question marked as Top-ranking reply
User profile for user: Camelot
Camelot
User level: Level 9
58,173 points

Posted on Nov 17, 2025 2:14 PM

Your REGEX() matches any occurrences of 'TBA' as a single word (as denoted by the leading and trailing \b markers).


Since one of the cells contains 'Binding - size TBA', it matches.


If you want the COUNTIF to match cells that contain only 'TBA' then you can use


=COUNTIF(A2:Q7,"TBA")


and nix the whole REGEX(). TBA embedded within a larger string will be ignored.


Without knowing what your intent is in this way, it's hard to be more specific.

View in context
4 replies
Question marked as Top-ranking reply
User profile for user: Camelot
Camelot
User level: Level 9
58,173 points

Nov 17, 2025 2:14 PM in response to HayleyHatzi

Your REGEX() matches any occurrences of 'TBA' as a single word (as denoted by the leading and trailing \b markers).


Since one of the cells contains 'Binding - size TBA', it matches.


If you want the COUNTIF to match cells that contain only 'TBA' then you can use


=COUNTIF(A2:Q7,"TBA")


and nix the whole REGEX(). TBA embedded within a larger string will be ignored.


Without knowing what your intent is in this way, it's hard to be more specific.

Reply

Numbers formula showing a message when there are no 'TBA' cells

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up