Skip to main content
Molly Steffe (MLG Capital) ha fatto una domanda in #Formulas

Our users would like the task due date to default to 2 business days from the date the task is created. Ex) if the task is created on a wednesday, the due date should be Friday and if the task if created on Thursday, the due date should be Monday. We have tried several formulas in the the default value (global actions) but they only work half the time. Has anyone had any success with this?

Below are the formulas we have tried already that haven't worked (we've been checking every day):

 

  • CASE( MOD(TODAY() - DATE(1900, 1, 7), 7), 3, TODAY() + 2 + 2, 4, TODAY() + 2 + 2, 5, TODAY() + 2 + 2, 6, TODAY() + 1 + 2, TODAY() + 2 )

 

  • CASE(MOD(TODAY-DATE(1900,1,7),7),3,TODAY+2+3,4,TODAY+2+3,5,TODAY+2+3,6,TODAY+1+3,TODAY+3)

 

  • CASE(WEEKDAY(TODAY()),3, TODAY() + 2 + 2,4, TODAY() + 2 + 2,5, TODAY() + 2 + 2,6, TODAY() + 1 + 2,TODAY() + 2)

@Gwenn Ferguson 

11 risposte
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    3 ago 2022, 14:04

    Forget my last comment, you coudl use TODAY() instead of DATEVALUE(CreatedDate):

    TODAY()+

    CASE(WEEKDAY(TODAY()),5,4,6,4,7,3,2)

0/9000