Good Day Smartsheet Community:

Can I add IFError to this Formula? I tried several times but I keep getting an incorrect or Unparseable

=ROUND(AVGW(CHILDREN([% Complete (Planned)]3), CHILDREN(Duration3)), 2)


Best Answers

  • Anthony Barthelemy
    Anthony Barthelemy ✭✭✭✭✭✭
    Answer ✓

    Thanks, that worked. I had my parenthesis in the wrong place.

    I have another Formula Issue. If I use 0.5 (half Day) for Duration, my % Complete (Planned) jumps to 200%. However, it works just fine with whole numbers (i.e, 1 Day).

    =IFERROR(IF(AND(TODAY() >= [Start Date (Planned)]2, TODAY() <= [Finish Date (Planned)]2), ROUND(NETWORKDAYS([Start Date (Planned)]2, TODAY()) / Duration2, 2), IF(TODAY() > [Finish Date (Planned)]2, 1, 0)), 0)

    Any idea on whats causing that?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!