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.

Promise Dates

Tony Gentry
edited 12/09/19 in Archived 2015 Posts

Is there a way to formulate a promise date based on current workload (number of request)? 


  • Brett Evans
    Brett Evans ✭✭✭✭✭✭

    The simple answer is yes.  As you probably know just add date_value + numeric_value.  


    The more difficult problem is counting your current workload.  I don't know how your sheet is set up, but you probably want to use 


    To get the numeric_value to add to your current date_value.


    A more specific answer would depend on how your spread sheet is set up.  Can you provide a link or screenshot?


This discussion has been closed.