how to automatically add a date when another cell value is added
I am trying to add in a formula to automatically add the date in the "date completed" cell when the "completed initials" drop down value has been added. What is the correct formula to make this work?
I want the date to automatically populate when the job has been completed.
Answers
-
Have you looked into the Record a Date Automation?
-
Yes. I dont have their business or enterprise plan though.
-
Ah. I didn't realize that wasn't available on individual plans.
There may be a way using Zapier, but I am not too familiar with that particular option.
You could insert a column that has unique data on each row along with a system generated Modified (date) type column. Then set up another sheet. Once that is set up, you should be able to use a copy row automation triggered when the initials column is filled out. Then we could use an INDEX/MATCH formula to reference the copy sheet and pull the date from there. Does that sound like an option?
-
I was more looking for the "IF" formula like excel has but I may try the modified date if I cannot find it
-
There is no way to do it with just a formula in Smartsheet unfortunately.
-
Bummer. Thanks for you help though
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 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