Red Gregory

View Original

Notion Formula: Find Percentage Of Complete Checkboxes

Checkbox Formula

round(100 * (unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final"))) / 4) / 100

  • Find the sum of all checkboxes:

    • round(100 * (unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final"))) / 4) / 100

  • Divide the sum by the number of checkboxes:

    • round(100 * (unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final"))) / 4) / 100

  • Round the entire calculation with the “round” function:

    • round(100 * (unaryPlus(prop("Discuss")) + unaryPlus(prop("Procedures")) + unaryPlus(prop("Review")) + unaryPlus(prop("Final"))) / 4) / 100

More Formula Tips

See this content in the original post

View Example In Notion


See this gallery in the original post