Percent of Text Filled | Notion

% Filled `if`

round((if(empty(prop("Text 1")), 0, 1) + if(empty(prop("Text 2")), 0, 1) + if(empty(prop("Text 3")), 0, 1)) / 3 * 1000) / 1000

% Filled `toNumber`

round((toNumber(not empty(prop("Text 1"))) + toNumber(not empty(prop("Text 2"))) + toNumber(not empty(prop("Text 3")))) / 3 * 1000) / 1000

<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

</aside>