Need a formula to see how many rows in a column are left blank

1

Working on a sign up sheet and would like to have a summary of how many days/shifts were left blank.

Looking for a formula to tell me X number of shifts are not accounted for/ x number of rows are blank

2

Hi @Adriana_Kincaid,

And welcome to the community!

I’d use a canvas formula, anything outside of a table, and then it’s really just referencing the table, then filter by a criteria of a column, like checking to see if it’s blank, then counting. So each step in the formula looks like this…

[My Table].Filter([Column 1].IsBlank).Count()

2 Likes