Updating a Date Column after another cell is updated.

Eric Glassey · 05/27/20

I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected.

For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. I have a three date columns that would create or update to today's date whenever their respective choice was selected.

Andrée Starå · 05/27/20

Hi @Eric Glassey

Yes, we can develop a solution using the method in my post here:

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

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 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!

Andrée Starå · 05/27/20

Hi @Eric Glassey

Yes, we can develop a solution using the method in my post here:

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

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 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!

Eric Glassey · 05/27/20

That worked like a charm. Thank you so much. That saves a bunch of data-entry hours.

Andrée Starå · 05/27/20

@Eric Glassey

Excellent!

You're more than welcome!

Updating a Date Column after another cell is updated.

Best Answer

Answers

Help Article Resources

Categories