Auto populate based on entry in another column

I have a column "Actual Status" that I'd like to auto populate based on the "Planned Finished Date". Can anybody help please

Best Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Answer ✓

    Hey JGF -

    Assuming you want to be able to manually adjust "Actual Status" -

    Create a helper column which looks to see if the "Planned Finish" date is passed:

    =IF([Planned Finish]@row < TODAY(), "LATE", "")

    Then Run an Automation Workflow - which triggers when this helper column changes to "Late", so that it changes "Actual Status" to "Late"

    Let me know if that helps!

    -Jon Mark

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓


    You're more than welcome!

    To build upon Jon's suggestion. You'd add a condition (see below)

    Also, this could be developed further to automate more of the stages if you don't want them to be manually updated.

    Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!


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

    W: | | 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!