Lock or Store Date/Value Solution without using Zapier

2

Comments

  • @Andrée Starå - could you please share your example with me as well? Sending you an email now.. Thank you in advance!

  • Hi @Andrée Starå, I would love to use this functionality. Can you please share an example? I will send an email with my details.


    Thank you kindly

  • Cleversheet
    Cleversheet ✭✭✭✭✭✭

    Kelly & Andrée and others,

    I believe the new "Record a Date" Workflow feature will meet this need in certain cases. Still wishing, though, for a way to detect the row number I'm on, and be able to operate on that with formulas.

    Troy

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

    Hi @cleversheet,

    Yes, you're correct that some workflows won't need my workaround anymore, but for example, the Record a date feature only records the date and not the time (if you don't look at the cell history), and if you want to store/lock something time or something other than dates it's still needed.


    Regarding the detection of the row numbers.

    Can you describe how you'd want to use it?


    I hope that helps!

    Be safe and have a fantastic day!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.

  • Cleversheet
    Cleversheet ✭✭✭✭✭✭

    I've long wished I could automate "legal numbering" in certain sheets. Example:

    1. xx

    1.1 xx

    1.2 xx

    2. xx

    2.1 xx

    In this illustration, if I dragged 1.2 to just under 2. it would then be numbered 2.1 and its successor would become 2.2.

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

    @Kelly Kindred

    Yes, I'd be happy too! (just sent)

    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.

  • Ella
    Ella ✭✭✭
    edited 07/08/21

    Hi Andree @Andrée Starå ,

    I hope all is well.

    Is your solution working for extracting the exact time from a completion date column?

    Thanks

  • Clemente Inocente
    edited 07/23/21

    Moved comment

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

    Hi @Ella,

    I'm excellent, and I hope you are too!

    I stumbled over your question.

    Yes, it will work for that as well.

    I hope that helps!

    Be safe and have a fantastic weekend!

    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.

  • @Andrée Starå Please can you also send me the solution to capture a timestamp when recording a date in the automation. Thank you kindly

    Zelda

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

    @Zelda CARZELRD

    I'd be happy to share an example. 

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

    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.

  • @Andrée Starå Is it still possible to get your example, I'm hoping it will work for what I'm trying to do.


    Thanks,

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

    Hi @Gregory Watt

    I hope you're well and safe!

    Yes, I'd be happy to share an example. 

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

    I hope that helps!

    Have a fantastic weekend & Happy New Year!

    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.

  • HI Andree,

    Please could you share this example with me? A very simple step-by-step instruction would be really helpful!

    Thanks,

    Lydia

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

    Hi @LydiaBR

    I hope you're well and safe!

    I'd be happy to share an example. 

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

    I hope that helps!

    Be safe and have a fantastic weekend!

    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.