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
Comments
-
Try putting this around your formula:
=IFERROR(all your old formula goes here minus the = sign, "error that used to work")
Craig
-
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...
-
Caroline,
Certainly sounds like a problem with Smartsheet.
They changed things and missed somethign in testing, it appears.
Craig
-
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!
-
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
-
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!
-
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
-
Hi Kennedy
Thank you very much! Now it is working!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives