Check the box if it's a Monday

MCastillo
MCastillo
edited 12/09/19 in Formulas and Functions

I have a [Due By] date column and a [Monday] checkbox column.  I'm trying to create a formula that will check the box on any [Due By] that is a Monday.

I got as far as getting the box to check if today is Monday: 

=IF(WEEKDAY(TODAY()) = 2, 1, 0)

But can't figure out the rest. 

Thanks for your help!

Tags:

Comments

  • You have done the hard yards, just replace TODAY() with [Due By]@row

     

    =IF(WEEKDAY([Due By]@row) = 2, 1, 0)

  • MCastillo
    MCastillo
    edited 02/11/19

    Genius!  Thank you, Andrew!

    I'm new at all this. 

    Another thing I'd like to do that's related to this is to have Smartsheet send me an alert on Monday mornings that tells all the things that have due dates this week, including that Monday.   But I can't figure that out. 

    I'm thinking it would have something to do with changing the formula so the box is unchecked and it only checks once that Monday arrives.  Then the alert can be "When a row is added or changed, when Monday changes to Checked..."  However I don't know how to finish the alert to be sure it's sending me all the things due that week.  : (   

    Any thoughts on that? 

     

     

     

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi,

    I'd recommend setting up a report instead and have that send automatically each Monday or whatever makes sense.

    Would that work?

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!