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)? 

Comments

  • 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 
    COUNT(range_start:range_end)

    COUNT(CHILDREN())

    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?

    -Brett

This discussion has been closed.