Forum Discussion

steigelbill's avatar
steigelbill
Frequent Visitor
6 years ago
Solved

Return a Date based off another non-date value

Hello all,   I have a table with 2 columns: Category and Value. Based on the Category I want to add a date column.   The categories are Shipping Today which should give today's date, Next Consol...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    steigelbill - Perhaps:

     

    Column =
  SWITCH([Category],
    "Shipping Today",TODAY(),
    "Next Consolidation",TODAY() + 6 - WEEKDAY(TODAY()),
    BLANK()
  )
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

steigelbill - Perhaps:

 

Column =
  SWITCH([Category],
    "Shipping Today",TODAY(),
    "Next Consolidation",TODAY() + 6 - WEEKDAY(TODAY()),
    BLANK()
  )
  • steigelbill's avatar
    steigelbill
    Frequent Visitor
    6 years ago

    Works like a champ! It's always great to find new functions.  Thanks much Greg!