how to get sum of a column to include only certain date range
Please could someone help me with this?
We have recently upgraded to be able to use the summary sheet as well as automated workflows, but neither of these have helped, and I think it maybe a simple formula issue?
Basically, we use smartsheet for customers to place preorders of different products (approx 50 different columns for products), and the orders come in onto new rows. WE then need to total these rows using the sum function. We currently update the sum to include recently added rows, but I would like to automate this so that it automatically calculates the totals whenever a new row is added.
I have tried something similar to the following formula =sumif(date column:date column, MONTH=11, [Product1:Product1]), but it keeps saying 'unsurpasseable' and I don't know why.
POssibly because the sheet uses a lot of parent and child rows?
Hope this makes sense. Would be really grateful of some help on this.
Help Article Resources
Check out the Formula Handbook template!