Automation compare dates in two columns

edited 12/09/19 in Using Smartsheet
06/29/19 Edited 12/09/19

Hello, I am new to SmartSheet and is playing around with the new automation system

I have 2 columns start date and end date, I want to create an alert to some people that if the start date goes past end date and at the same time make end date blank.  From what I can see I can only compare a date column with a specific date and not able to compare it to other date column.  I would love to have some insights or directions to go about this problem.  Thank you.

Comments

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

    Hi John,

    You can compare a date column with another one with the help of a formula, but you can't make the end date blank at the same time.

    A workaround could be to use a third-party service like Zapier to delete the end date.

    Would that work/is that an option?

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    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.