Is there a formula for checking a box if date in another column is changed?

09/21/21
Answered - Pending Review

I have a checkbox column that I've set up a "Change Cell Value" automation to check the box when the date in another column (Due Date column) is changed. However, I would like the box to be checked only if the change in date is greater than the prior date... as a way to indicate an extension has been granted. Is there a way to set that parameter? If not with the automation tool, would there possibly be a way utilizing a formula?

Answers

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

    Hi @Sara Ross

    I hope you're well and safe!

    Please have a look at my post below with a method I developed. You could combine it with another helper column that checks if the date is later or not and then use the change a cell action in a workflow to check the box.

    More info: 

    Make sense?

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Sara RossSara Ross ✭✭✭✭

    Thanks for the suggestion. I was able to create another sheet (I called it Feeder Sheet) to receive a copy of the row when the Due Date changes on the original sheet, but am having difficulty in the specific steps to take after that point.

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 09/21/21

    @Sara Ross

    Happy to help!

    I'd be happy to share an example. 

    Please send me an email at [email protected], and I'll share it with you.

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.