How to create a deadline column for it to be three days before the deadline that was put in the form

I am trying to create a workflow (I think) that when someone completes my form and enters their requested deadline in the form, there will be an automatic column that will show three days before that deadline requested. I want that date to automatically show three days before the requested deadline so that we can get enough time to have approval from our managers and make any changes to what is being requested before the requested deadline.

Basically, how do I have a column to automatically show three days before a requested deadline?

Answers

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

    Hi @Micah Sheerin

    I hope you're well and safe!

    Try something like this. (and make it a column formula)

    =[Requested Deadline]@row - 3
    

    Did 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 EXPERT CONSULTANT & PARTNER

    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.