AVERAGEIFS or AVG(COLLECT)

Options

Fairly new to Smartsheet but well versed in Excel. There has been a learning curve, but I have overcome it until now.

I need to write a formula that will average the "Days Off" Column if the "Actual Delivery Date" Column is within a certain date range.

For this example, we can use a date range in the "Actual Delivery Date" column of 1/3/22 - 1/7/22.

Any help the community can provide would be Greatly Appreciated!


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!