How to show time when a box is checked?

Jhoaas · 07/10/23

I have a basic work ticket sheet setup (from a template), and when someone submits the form, it records the created date AND time without issue. But i also have a "resolved date" column, and all i want that to do is record the date AND time when i change the dropdown in "ticket status" to resolved.

This seems like it should be a very basic ability, but for some reason i cant get any date columns (other than created date) to show a time at all. In another thread someone mentioned a formula for time, but i cant figure out how to apply that in this situation: =[Due Date]@row + ""

Andrée Starå · 07/10/23

Hi @Jhoaas

I hope you're well and safe!

Please have a look at my post below with a method I developed.

More info:

Lock or Store Date/Value Solution without using Zapier

Andrée Starå

May 24, 2020

Hi all,
I hope you're well and safe!
I've developed a solution that lets you store the date or value.
You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.
We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id/value that we can use, it will work.
Also, this opens up more options with auto-numbering and similar.
Depending on other workflows, you could reuse one sheet for multiple workflows.
I hope that helps!
Let me know if you have any questions!
Stay safe and have a fantastic day!
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 helpful. It will make it easier for others to find a solution.

Would that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jhoaas · 07/10/23

That seems awfully complicated--does Smartsheet not have an ability to record time? They must if they are able to record the created on time, so im not sure why they cant have it for other columns. I really just want something as simple as "box was checked at 4:30 pm". Thats all i need. I dont need it to calculate anything or reference anything, i just need the approximate time i checked the box.

Andrée Starå · 07/10/23

@Jhoaas

Unfortunately, there isn't a "Time feature" at the moment built-in, so a workaround, using my method, the Smartsheet API, or a 3rd-party integration, is required.

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jhoaas · 07/10/23

Ok, for now it looks like just using "modified date" will at least record the exact time i last changed something in the row, that will have to work for now.

It just really blows my mind, that they dont have something as simple as recording the time as an option when creating workflows, etc, especially when they are already able to pull the time for other columns. I feel like this should be so simple--do something to a column, show the time that happened in another column--done.

Heather Max · 07/10/23

I agree that this should be a feature. If you can right click on that cell and view the cell history that has a time stamp and shows who made the change (and all other changes ever made to that cell) then that information is already recorded somewhere. Why not just allow that saved information to be put in another column.

Heather Max · 07/10/23

Have you tried the automation workflow "when triggered" then select the status column, choose to have it trigger only when that field = resolved (or whatever other terminology you like to use), then select "Record a Date" and choose the Date Column you wish to record it in. It should record the date and time if that cell is formatted to include the time.

Jhoaas · 07/10/23

I did try that first, but it only enters the date, and not the time. How do you format it to include the time?

Smartsheet Basics

Smartsheet Basics

How to show time when a box is checked?

Answers

Lock or Store Date/Value Solution without using Zapier

Quick Links

Categories

Trending in Smartsheet Basics

Link Report in Form

Displaying report summary data in a Dashboard chart widget

Square Radio Buttons?