auto completion date

Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for our "Completion Date" column to automatically show the date when a status is changed to "Complete". I don't care about any other status options. Is it possible to assign a date?

Thx,

Jim

Find more posts tagged with

Construction

Calendar View

Support

Conditional Formatting

Cell linking

Comments

Andrée Starå

Hi Jim,

Welcome to the Community and the wonderful world of Smartsheet!

Unfortunately, it's not possible at the moment to store a date automatically, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Two possible workarounds could be to either use the Automations and lock the row, and then the date would be stored, but if you change anything, it would update or to use a third-party service like Zapier.

What do you think? Would any of those methods work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

jbrigance101486

Hi, thanks for the response. I know enough about Smartsheet to be dangerous. I looked in our Automations and it already has a lock row feature, but I don't see anywhere that it sets a date for that.

We have a Date Need By column, this is chosen manually by the requestor. We also have a Date Submitted column that appears to be automatic because it lists a time as well.

Thx,

Jim

Andrée Starå

Happy to help!

You'd use the System column, Modified and that would show the date when the row got locked if nothing else has changed in the row.

Make sense?

jbrigance101486

Yes, I think I got it! Appreciate it!

Andrée Starå

Excellent!

Happy to help!

jbrigance101486

Hi, sorry to bother you, but I have a question. Yesterday, I set up an "Auto Number/System" column and it showed a date and an aging column that generated a number to show the difference from the Need By date to the Completion Date. After sometime, the auto #/system formula and aging # disappeared. I set it up again this morning, and it worked for a bit, then it disappeared again.

Any ideas why it is doing this?

Thx,

Jim

Andrée Starå

Hi Jim,

I'm always happy to help!

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Sign in to join the conversation!

Quick Links

Trending discussions

Set Up Links for Board View
In my grid view, I added a column that takes a hyperlink but when I mosey on over to Board View, only some of the columns appear as attributes displayed on the card. Can I make the hyperlink appear here?
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…
Automatic Unalignment of Dashboard Widgets
Is anyone experiencing their dashboard widgets automatically being unaligned or they have moved a bit from your last save? I am the type where I like things clean and aligned. Some may say it's OCD. In Dashboard, this can mean the edges of my widget line up, each section is centered or same purposed widgets are the same…