lets say table 1 I use to collect data. Columns are: (header columns = *)
*A Full date
*B total revenue
I use numbers on the iPhone and use forms to input data.
A & B (header columns) use formulas:
A = column C, formatted differently.
B = sum of columns E & F.
C to F – entered into forms manually:
C – type date
D – pull down list of 3 names (joe, bob,Sam)
E – dollars
F – dollars
I have categories set up to see the table like this:
1st cat- date sorted by week
2nd cat- employee sorted by day
I need a way to see the total revenue per day without Changing categories.
to solve this I have table2 which has column A = column A from table1 (the date). i have sumif statements in columns B and C to get totals for sales and tips for each day. This works great if I remember to manually add rows, the data autofills as expected
However I don’t want to do that. How can i get the rows to auto generate after I add data to table1?