Counting the number of cells completed and displaying percentage

[Pierre_Bernat]

Hi,
I found a script enabling a percentage count: https://airtable.com/shr1uUxBtpin68DsN/tbl83MENluhVCm20y/viwuf0HQjtKfYVvmb and I would like to adapt it by counting the number of cells completed, in place of the direct input in the “Current” cell.

What type of formula can count the number of cells completed for a specific row?

Thanks for your help.

[ScottWorld · Accepted solution]

You would just need to create a formula field that uses the COUNTA function.

So, if you have 3 fields/columns that you want to count that are named “Column 1”, “Column 2”, and “Column 3”, your formula would look like this:

COUNTA({Column 1},{Column 2},{Column 3})

Use that formula for your “Current” field.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:

[Pierre_Bernat1]

:white_check_mark: Solution

[ScottWorld]

Haha, thanks! Do you happen to see a little solution checkbox at the bottom of my previous post? That’s what I was referring to. It should give you the ability to check that checkbox.