You're right, Odoo's spreadsheet application (which is part of Odoo's core modules) doesn't have the advanced "Custom Formula is" conditional formatting option that you find in Google Sheets or Excel.
You are not missing anything. Odoo's spreadsheet functionality is more basic in terms of conditional formatting capabilities. It currently offers a more limited set of predefined conditions.
Odoo's Current Conditional Formatting:
As of now (May 31, 2025), Odoo's spreadsheet conditional formatting typically allows you to set rules based on:
- Cell value being equal to, not equal to, greater than, less than, between, or not between specific values.
- Text content (containing, not containing, starting with, ending with).
- Date conditions (is, is before, is after, etc.).
- Blanks or non-blanks.
The Need for "Custom Formula is"
The "Custom Formula is" option is a powerful feature because it allows you to define much more complex and dynamic formatting rules based on formulas that can reference other cells in the row or even other parts of the spreadsheet. This is essential for many advanced data analysis and reporting scenarios.
Possible Workarounds (Limited):
While you can't directly use a custom formula, you might be able to achieve some limited conditional formatting effects by:
- Creating Helper Columns: Add extra columns to your spreadsheet that calculate intermediate values based on formulas. Then, apply conditional formatting to your target column based on the values in these helper columns. This can be cumbersome, but it's sometimes the only way to achieve a specific result.
- Using Odoo Studio (If you have Enterprise): Odoo Studio allows you to customize the views of your data. While it won't directly add conditional formatting to the spreadsheet itself, you could potentially use Studio to create a custom list view of your data with formatting applied based on conditions. This would be more of a visual representation of the data in Odoo, rather than within the spreadsheet app.
No, you're correct. 'Custom Formula is...' isn't currently a thing