When I check off checkbox , it adds the date. It shows me how many coffees I had today. I'm going to show you how to build this. We want to count how many today's we have in the B column. Equal rept coffee cup count. If the range is going to be B2, the criteria is going to be today. We need to check this off and get this. How do we do that? We go up to extensions appscript. write a function on edit with a capital E with an E inside of parenthesis with some curly brackets and we go variable today utilities do format date and we say new date and we're going to put in GMT + 6 our format mm/ DD/year year if E.trange with parenthesis is equal to 1 and E.trange

row greater than one and E.LA is true. Two equal signs curly brackets. Spreadsheet app.get active sheet .get range . E.trange.get row. That's the second column. Set value. And we're going to go back up to our variable today and write that