Counting the number of cells completed and displaying percentage

Question

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 Answer

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:

:white_check_mark: Solution

Pierre_Bernat1 · Answer

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:

:white_check_mark: Solution

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded