@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
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.
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!
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
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I've long wished I could automate "legal numbering" in certain sheets. Example:
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.
Yes, I'd be happy too! (just sent)
Hi Andree @Andrée Starå ,
I hope all is well.
Is your solution working for extracting the exact time from a completion date column?
I'm excellent, and I hope you are too!
I stumbled over your question.
Yes, it will work for that as well.
Be safe and have a fantastic weekend!
✅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!
@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
I'd be happy to share an example.
Please send me an email at [email protected], and I'll share it with you.
@Andrée Starå Is it still possible to get your example, I'm hoping it will work for what I'm trying to do.
Hi @Gregory Watt
I hope you're well and safe!
Yes, I'd be happy to share an example.
Have a fantastic weekend & Happy New Year!
Please could you share this example with me? A very simple step-by-step instruction would be really helpful!
This little formula is useful for a range of solutions, like working out if a date is in daylight savings time or not. The examples below reference a date field named [Date]. The first part of the formula finds the date of the seventh day of the month. This is done so that the number of days from Sunday can be subtracted:…
Here is a way to create reminders for Proof reviewers. This solution will: Send a reminder 5 days after the initial invite, if no one has responded to a Proof review request. Send a reminder 5 days after the last reminder, if no one has responded to a Proof review. Reset when a new Proof version is created. Some useful…
Hi all, I recently developed a cool solution to an issue that we had... how to build a custom schedule based on selections in an intake form. This solution leverages Bridge, but you could do the same thing using a third party integration tool. THE GOAL The process goal for this solution is: Collect project requests using…
©2023. All Rights Reserved Smartsheet Inc.