Sum of Totals by area and Date

Options

I am trying to set up a formula that does the following:

If in Work Log A, the Plant is X and the date range is between 10-1-2020 and now, what is the total cost of this time range for this sheet?

I also want to break down by monthly range:

If in Work Log A the plant is X and the date range is between 1-1-2021 and 1-31-2021, what is the total cost of this time range for this sheet?

I have similar formulas for the references in the other sheets, but what's hanging me up is trying to specify a date range within the formula.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!