We use Note fields in custom tables because decisions require rich text formatting (paragraphs, bullets, etc.).
Calculation fields cannot reference Note fields or determine whether they are empty.
As a result, formulas such as:
if(empty(field("Agreed Decision")), "TBD", field("Agreed Decision"))are not supported.
Executive Pivot reports show blank cells instead of meaningful placeholders like TBD.
Users have to create duplicate helper fields solely for reporting.
Allow calculation fields to:
Reference Note (rich text) fields.
Support functions such as empty() on Note fields.
Return Note field content while preserving formatting where possible.