how to automatically add a date when another cell value is added

s.kinsman76601

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.

Paul Newcome

Have you looked into the Record a Date Automation?

s.kinsman76601

Yes. I dont have their business or enterprise plan though.

Paul Newcome

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?

s.kinsman76601

I was more looking for the "IF" formula like excel has but I may try the modified date if I cannot find it

Paul Newcome

There is no way to do it with just a formula in Smartsheet unfortunately.

s.kinsman76601

Bummer. Thanks for you help though

Paul Newcome

Sure thing. 👍️