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!