Showing All Checkboxes in a Record as a Percent Complete Column


#1

Hi all,

I need some help. I have a table that is mostly just a series of checkboxes (Step 1, Step 2, Step 3, etc) to show whether a task is complete. I’ve been charged with finding a way to create a column that tabulates across a record, notes which of those columns are checked, and expresses the total as a percent, thereby immediately showing how complete that particular project is.

Can Airtable do that? I thought that a Formula column could manage it, but I’m new at this, and exceedingly dunce-like. I’m flunking hard. Does anyone know how I might get that accomplished?


#2
(SUM({Task 1},{Task 2},{Task 3})*100)/COUNTALL({Task 1},{Task 2},{Task 3})

Both the SUM() and COUNTALL() functions must have all task fields defined inside them, and you’ll want to set the formatting to ‘Percent’.

image

The formula works because a Checkbox field returns a value of 0 if it is unchecked, and 1 if it is checked.

So the COUNTALL() function is just saying “Count the total number of fields I put in here” - which in my example is 3.

The SUM() function is saying “Total the values returned by all the fields I put in here” - which is 1 x the number of checked fields.


#3

You, sir, are a blessing! Thank you so much both for the formula and the thorough explanation. That worked beautifully.

Many, many thanks, Jeremy!