My status field for the Products module is a calculated field with the following formula:
This calculated field is not working correctly on the Quotes record view. When the order stage changes on the Quote, none of the line items are getting their status updated. I have a couple of other calculated fields that depend on the value of the status field so I need it to be updated in real time on the record view when the Quote field changes. On save, the field works correctly, it just doesn't seem to get triggered to update on the Quotes record view.
Any ideas on how to get it to work?