Promise Dates

Tony Gentry

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

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