Due Date dependent on predecessor AND allocation %

edited 12/09/19 in Smartsheet Basics


I'm trying to get end dates to change based on estimated hours AND allocation %.


Is that possible? How do you do this? 




  • L_123
    L_123 ✭✭✭✭✭✭

    the formula

    =date1 + 1

    will add a single day to the date in the date column first row.

    knowing that dates can be manipulated this way, we can use a simple statement to adjust the date

    =date1 + ([Estimated Hours]1*Value + [Alocation %]1*Value)

    If you want to make it more complex you can use an if statement to make a faux variable to adjust the date based on criteria.

    =date1 + if([Allocation %]1 > 50%, [Stock Project Duration]1 * 1.25)


    Or something like that.