How to get average # Workdays by Contract Type

Joan156 ✭✭
edited 06/30/23 in Formulas and Functions

I'm stumped and hoping the community can help.

Within Sheet Summary of my master grid, I am trying to create an average formula that calculates the average # of workdays by contract type within a specific month--in this case, June 2023. This data will be used in a Monthly Dashboard.

For example:

"NDA/CDA (Non-Disclosure Agreement)" should equal 8.25

"SOW (Statement of Work)" should equal 3.333

Best Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    =AVG(COLLECT([# Workdays from Receipt to Fully Executed]:[# Workdays from Receipt to Fully Executed], [Contract Type]:[Contract Type], "NDA/CDA (Non-Disclosure Agreement)", [Today's Date]:[Today's Date], MONTH(@cell) = 6, [Today's Date]:[Today's Date], YEAR(@cell) = 2023))

    You will just need to substitute in Month/Year/Contract Type as needed.

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    Awesome! I'm glad it's working for you. 👍️


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!