Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

How record a date automation work?

Hi, I'm having trouble using the record a date automation.

as you can see in 1st picture, I create record a date when "send noti to slack" is checked

in 2nd picture, every change I made in that check box is from 25-Nov-2021 but record date show 24-Nov-2021

does anyone know why? and what I have to do to make it record the day I check the box (25-Nov-2021)

Thank you very much.

1.jpg 2.jpg


Answers

  • ✭✭✭✭✭

    What is the run workflow trigger? It might be set to "Daily" when it should be "When triggered".

    image.png


  • ✭✭
    edited 11/25/21

    @Devin Lee thank you but it's not the case here, it's set to "When triggered"

    image.png


  • Community Champion
    edited 11/25/21

    Hi @Hoang Le

    I hope you're well and safe!

    It's probably a timezone issue, and you'd need a formula to correct it.

    I'll get back to the post if I can find the details.

    This might 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: 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.

Trending in Smartsheet Basics