Counting multiple columns across a row with an IsNotBlank status

Hi,

I have a table where each column is a different lunch order for the week and each row is the individual who is getting those lunches. In some cases a day may be blank.

I am trying to create a new column with a formula that will count how many lunches that individual ordered. I feel like I’m on the edge of having it correct but I seem to be stuck when trying to notate that I need more than one column added to the equation.

Here are two formulas that give me the right number when ONLY looking at Monday, but I do not understand how to add Tues, Weds, Thurs, Fri etc.

  • thisRow.CountIf(IsNotBlank(thisRow.[Lunch Order Mon]))

  • thisRow.Filter(IsNotBlank(thisRow.[Lunch Order Mon])).Count()

Any help is appreciated. Thank you!

hi @Amy_Spalletta , sharing a doc or at least good screenshots enables others to understand your challenge better. Would that be possibe?
cheers, Christiaan

1 Like

well, as far as I can see this is counting the item in a list

List(thisRow.Monday,thisRow.Tuesday,thisRow.Wednesday,thisRow.Thursday,thisRow.Friday).Count()

let me know it this helps or not

cheers, christiaan

3 Likes

THANK YOU. I was trying to make it more complicated than it needed to be. This works!