Calculation columns should recognize note field values as blank/0 characters when content has been deleted Merged

What is the challenge?

When using a calculation column in a report to capture if a note field is blank there are currently two states of emptiness. The first is when the note is truly empty and has a character length of 0, the second is when a note previously had content but was then deleted which has an html sting value of 12 characters. To work around this requires one to combine two 'if' statements together to compare against both empty options and requires a value for if the note field is not blank.

What is the impact?

The formula is cumbersome. It requires a value to display if the note field is not blank which we do not want. It is not clear when a note field is truly blank (0 characters) or if the value has been deleted (12 characters) without searching through history which is too time consuming.

Describe your idea

Calculation columns should recognize note field values as 0 characters when content has been deleted.