Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Calculating Avg Workdays w/ Conditions

Hello!

I'm currently trying to calculate the average amount of workdays it takes for each person to complete a specific request on a metrics sheet from a parent sheet. For example: How long does it take me on average to complete a FOIA request? How long does it take me on average complete a litigation request?

Request Type = Type of Request (In this instance, FOIA)

AVG WDAYS = Column from parent sheet that has a formula calculating the average workdays for each specific line item to be completed

PLU Assigned = Person assigned to this request

=IFERROR((AVG({AVG WDAYS} = "", "", IF({Request Type}, CONTAINS("FOIA", @cell), {PLU Assigned}, HAS(@cell, "Bridgett Fenner")))))

I've made several adjustments since this morning, and moved around parentheses.

I'd be grateful for any insight! Thank you in advance. :)

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

  • I have a pretty basic sheet that I am using to develop a formula, and am encountering an issue I haven't seen before. The formula isn't including my second row for some reason. It isn't a huge issue f…
    User: "jjg279"
    Answered ✓
    9
    2
  • I'm sure that this is an easy fix but I've tried a bunch of different ways and can't get this to work. I need to get the max date from a sheet to feed it into my meta data sheet (dates are stored in d…
    User: "susanmgfin"
    Answered ✓
    8
    2
  • I need help to come up with the risk formula. I tried many different formulas and tried to modify it but just can't seem to have desired results. So these are the conditions I MUST meet: Program is a …
    User: "Ronak"
    Answered ✓
    29
    6