How to calculating the age of a cell in hours

wtcf

Background -

I have a Form, which outputs as a row in a Grid, an extract of which is as follows -

The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function).

Problem -

I am trying to find a formula-driven solution, which will populate the 'Task Age (hrs)' column with the difference in hrs between the value in ''Date Raised' and 'Current Date/Time' i.e. time elapsed in hrs.

The purpose of this is to track if a Task has been completed on time e.g. High Priority (4 biz hrs), Medium Priority (8 biz hrs), and Low Priority (24 biz hrs).

As I see it, I have the following obstacles to overcome -

• Current Date/Time column - Is there a formula (e.g. something that can expand =TODAY()) that will populate the date and time in the same format as the 'Date Raised'' column?
• Task Age column - if the above is possible, how then would I compute the difference (in hrs) between the 'Date Raised' and ''Current Date/Time' column.

Thank you in advance, for any assistance anyone can offer.

Bassam Khalil

Hi @wtcf 

Hope you are fine, Unfortunately, this feature is not currently available. it's a good idea and you can submit Smartsheet Product Enhancement Requests using this form.

Andrée Starå

Hi @wtcf

I hope you're well and safe!

Please have a look at my post below with a method I developed that probably could be modified to work for your use case.

More info: 

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

Would that work/help?

I hope that helps!

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

wtcf

Hi @Andrée Starå - thanks for your response. Unfortunately, I haven't been able to understand your post, especially, it would be great for more context, and how I can apply the outlined principles to my use case?

Andrée Starå

Hi @wtcf

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD