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.

Release 2016-08-06 Duration

J. Craig Williams
J. Craig Williams ✭✭✭✭✭✭
edited 12/09/19 in Archived 2016 Posts

We can no longer use DURATION in a formula like MIN or MAX and I assume others.

Even more oddly

 

=MAX([Planned Duration]10, 4)

throws an error.

 

=MAX([Planned Duration]10)

does not.

 

just to be sure

=MAX(0,4)

does not either.

 

I'm not a happy customer today.

 

Craig

· Share on FacebookShare on Twitter

Comments

  • Kennedy Stomps
    Kennedy Stomps Employee

    Hi Craig-- Our Development team is looking into this right now. We think the issue is with the threshold value--the second value in the function--rather than with the formula referencing a Duration value specifically. I want to sincerely apologize for the disruption to your work, and I'll keep you updated via this thread as soon as I have more information on resolution for this.

    · Share on FacebookShare on Twitter
  • Kennedy Stomps
    Kennedy Stomps Employee
    edited 08/09/16

    Hi Craig-- Just wanted to let you know that this issue should have been resolved by a bug fix pushed last night--let me know if that doesn't seem to be the case on your end!

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    The biggest sheet with this problem appears to be OK now.

    Thanks.

     

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories