I have a number formatted line item, i want to flag this field in another text formatted line item.
saying its " error in value" else " No error", based on blank or non blank of first line item.
(Only if required) Use TEXT() function to convert number to text in your formula, to validate your required condition
Otherwise, I agree with Bram & Niranth.
Hi @MadhabikaM ,
You can use the formula "<> 0" and achieve your results.
There is no requirement to convert the values into text, You can directly refer the 'number formatted line item' and use the condition =(equal) or <> (not equal).
I'm suggesting this because converting numbers to text will all another additional layer of calculation and is not best practice.