Automated date due to change in dropdown list
Hi folks!
We're trying to set up a sheet where we are able to automated fill out different date columns due to a change within a dropdown column.
If entry of the status dropdown is changed to pending, the current date should be displayed in the Date Pending column and - important - being locked for any changes. So that if the status is changed again to another value (e.g. Start) the date in the Date Pending column stays the old one, but the current date is displayed in the Start Date column. I hope this was understandable 😣
First try formular was =IF(Status@row = "Pending"; TODAY(); "")
For sure that does not work as it did not contain the requirement of lock the first date entered. The moment the status is changed to another value, the date in the Date Pending column is deleted.
Anyone any thoughts on this?
Thanks and best regards,
Sebastian
Answers
-
Please have a look at my post below with a method I developed that would work for your use-case it seems.
More info:
Would that work/help?
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 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: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.
-
Hi Andrée
Thank you for your input. Unfortunately we're talking about a very big complicated sheet where we have many data involved and also many sub-sheets included (already with data mesh etc.). Therefore I think, that it is not possible for us to add another sub-sheet with additional meshs.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!