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


does not either.


I'm not a happy customer today.




  • Kennedy Stomps

    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.

  • 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!

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

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




This discussion has been closed.