After installing and activating the TablePress Extension, use the shortcodes_before_formulas=true configuration parameter to enabled Shortcode evaluation before formula calculation. You can add this to the “Configuration parameters” field in the “Advanced” section of the “Settings” sidebar of the “TablePress table” block in the block editor or by extending the Shortcode that you are using to embed the table to

[table id=123 shortcodes_before_formulas=true /]Code language: plaintext (plaintext)

If an Extension is useful for you, please check out the available TablePress Premium features and consider getting a Premium license plan, which bring even more features for you and your site visitors. Thank you!