Due date
Hi,
I have set up an automation to automatically record date when an attachment is added as a "CAP received date" . But if multiple attachments are added the system records the date to the date of the last submitted attachment. Is there a way to lock it to the first date recorded?
Answers
-
Hi @Vinodini
I hope you're well and safe!
You can add a so-called helper (checkbox) column, a condition to control if it's checked, and another action that checks the box when an attachment is added.
Make sense?
Did that work/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, Awesome, 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.
-
So is the helper column just a regular column and i add a condition to check off when an attachment is added? Will it work if i change my automation from attachment added to record the date if its checked in the helper column?
Thank you so much for helping me with this!!
Best,
Vino
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!