Lock or Store Date/Value Solution without using Zapier

Susan Albers · 11/18/20

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

Kelly Kindred · 01/11/21

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 · 01/12/21

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å · 01/12/21

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!

Cleversheet · 01/12/21

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å · 01/13/21

@Kelly Kindred

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

Ella · 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 · 07/23/21

Moved comment

Andrée Starå · 08/27/21

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!

Zelda CARZELRD · 09/12/21

@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å · 09/13/21

@Zelda CARZELRD

I'd be happy to share an example.

Please send me an email at andree@workbold.com, and I'll share it with you.

Gregory Watt · 01/07/22

@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å · 01/07/22

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 andree@workbold.com, 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!

LydiaBR · 01/24/22

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å · 01/29/22

Hi @LydiaBR

I hope you're well and safe!

I'd be happy to share an example.

Please send me an email at andree@workbold.com, 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!

Lock or Store Date/Value Solution without using Zapier

Comments

Categories