Evaluates to true if value is an error.
Syntax
is_error(value)
value can be an expression, any data type, or any Search Ads 360 variable.
Examples
-
Returns "1.067,30" if that’s a valid numeric format for the advertiser. Otherwise, it converts "1.067,30" to a valid format:
if( is_error(to_number("1.067,30")), substitute( substitute("1.067,30", ".", ""), ",", "."), "1.067,30" )
-
Returns true if the number format is invalid for the current advertiser:
Is_error(to_number("1.0,67"))
-
Returns true if the specified formula column is invalid for the current context::
Is_error(c:”PLARevenue”)