Forum Discussion

JulieBowers1's avatar
JulieBowers1
Qrew Trainee
2 years ago

Override a date formula field?

Hello, I've created a formula date field to auto-populate the date two weeks from today today()+Days(14) but I want to allow the users to override it.  Normally they would have a call eve...
AshleyHarris's avatar
AshleyHarris
Qrew Trainee
2 years ago

Hey Julie, 

Try creating a regular Date field and another Formula Date field. Make the Date field your "manual" entry. Personally, I like to include "Manual" in the field name. In the 2nd Formula Date field, use the formula below. 

Nz([Call Date (Manual)],[Call Date +14])









------------------------------
Ashley Harris
------------------------------
  • JulieBowers's avatar
    JulieBowers
    Qrew Member
    2 years ago

    Thank you both for the suggestions! This will definitely work for us!



    ------------------------------
    Julie Bowers
    ------------------------------