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

Attachments with Widgets
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…