Hi,
I want to apply formatting by condition but it doesnโt work as expected or I miss something.
When I test the formula, expression results are just right but it doesnโt apply right formatting it applies like all conditions are TRUE.
Thanks for help.
Are you trying to apply Formatting rule?
Please screen shoot the formatting rule and what is your expectation to make it work?
Thank you for your response, here is the screenshot.
Delete the IF.
There is no if statement in the formula. it is the name of the formatting rule.
Oh shoot. Iโm dumb and didnโt even notice that was the name field.
Have you made sure to Save all the changes?
Yes, it didโt change. I deleted the โ0โ values from my spreadsheet and tried ISBLANK formula but didโt succeed. I tested both formula, results were given true โy/nโ but it applied formatting wrong to all.
For giggles, flip the expression so the 0 is first and try that.
The column values appear to be grayed-out. Or do you mean the column headers?
Yes all columns values are grayed out, but for some products I have stocks and donโt want them to be grayed out.
As @Bahbus noted, make sure all of you changes are saved. Format rules often donโt work properly until saved in the app editor.
What other format rules do you have?
I see, and i have exprienced with my other apps beforeโฆ Here is the screenshot below that shows other format rules already disabled yet it didnโt work.
Looks like a bug to me, then. Please email support@appsheet.com for further assistance.
Ok, merci
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |