Check box if date is tomorrow.

Hi all, I have this formula, =IF(OR([Start Date]@row = TODAY(1)), 1). It works currently and checks the box if its tomorrow. The only issue is that on Friday I need it to check the following Monday.

Any help would be amazing!!

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭
    Answer ✓

    I think I have got it. Try this

    =IF([Start Date]@row = TODAY(1), 1, IF(AND(WEEKDAY(TODAY(1)) = 7, [Start Date]@row = TODAY(3)), 1))

    The formula will check the box is start date is tomorrow. If start date is not tomorrow, then it will check if tomorrow is Saturday AND if the start date falls on a Monday to check the box

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!