#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Problems with formula AVGW

Options
edited 12/09/19

Hi

The formula AVGW is not working anymore with the column duration.

I mean when we write: AVGW(CHILDREN([% Planned]8), CHILDREN(Duration8)) and duration is in days 1d, 2d, etc... the formula doesn't count the column duration as a number.

This starts after the Smartsheet update!

• ✭✭✭✭✭✭
Options

Try putting this around your formula:

=IFERROR(all your old formula goes here minus the = sign, "error that used to work")

Craig

• Options

Craig,

But is this not a problem related to Smartsheet? Because it doesn't make sense, if a copy the duration value in a "text/number" column my formula works...

• ✭✭✭✭✭✭
Options

Caroline,

Certainly sounds like a problem with Smartsheet.

They changed things and missed somethign in testing, it appears.

Craig

• edited 08/08/16
Options

I know.. the problem is this formula we use in MANY MANY smartsheets here.

The complete formula is:

=IF(COUNT(CHILDREN([% Planned]6)) > 0, ROUND(AVGW(CHILDREN([% Planned]6), CHILDREN(Duration6)), 2), IF(Duration6 = 0, IF([End Date]6 < TODAY(), 1, 0), ROUND(IF([Days until today]6 / Duration6 > 1, 1, IF([Days until today]6 / Duration6 < 0, 0, [Days until today]6 / Duration6)), 2)))

And the problem appears when the line has children...

I don't know how to fix this!

• ✭✭✭✭✭✭
Options

Caroline,

I just posted this:

https://community.smartsheet.com/discussion/release-2016-08-06-duration

It appears that the DURATION column is not accepted in many formulas.

If you can wait, Smartsheet is just getting their coffee's at work. Maybe they have a quick fix.

I've already got a work around, I think, but I don't want to implement it if I don't have too.

Not unless Smartsheet will pay me for the lost time.

Craig

• Employee
Options

Hi Caroline! This is somethign our Development team is looking into right now--it does appear to be a bug. Thanks for bringing this to our attention, I'll update this thread when I have more information about resolution.

Craig, I think the issue you reported in your post is a little different, so I've responded there!

• Employee
Options

Hi Caroline-- Just wanted to let you know that our developers released a fix for this bug last night so the issue should now be resolved, let me know if you don't see this fixed on your side

• edited 08/09/16
Options

Hi Kennedy

Thank you very much! Now it is working!

This discussion has been closed.