Forum Discussion

KimNguyen's avatar
KimNguyen
Qrew Member
4 months ago

Help with a simply IF formula

Hello!

I have been stuck on this problem for HOURS. Please help :'(

I have a check box that I would like CHECKED when:

  • Referenced Date Field is after January 1, 2024
    • All days before 1/1/24 is UNCHECKED
  • It has been at least 7 days since Referenced Date Field
    • If Referenced Date Field = 2/1/24, then it's checked if TODAY() = 2/8/24 

Here is the formula I have. The +7 days portion works but the before 1/1/24 doesn't work :(

If([Date Field] + Days(7) <= Today()

and

[Date Field] > ToDate(01/01/2024),

true, false)

Thank you in advance if you are able to help me solve



------------------------------
Kim Anh Nguyen
------------------------------

2 Replies

Sort By
  • ChayceDuncan's avatar
    ChayceDuncan
    Qrew Captain
    4 months ago

    If I'm understanding correctly you just need to make sure that anything before 1/1/24 is unchecked? You can do a condition that specifically calls that out like so if that's what you need:  

    if( 

         [Date Field] < ToDate("1/1/24"), false,

         [Date Field] + Days(7) <= Today(), true,

    false)



    ------------------------------
    Chayce Duncan
    ------------------------------
    • KimNguyen's avatar
      KimNguyen
      Qrew Member
      4 months ago

      Thank you SOOOOOOO much!!!



      ------------------------------
      Kim Anh Nguyen
      ------------------------------