Is there a way to display elapsed time for a project?

Dr. Steve Stutz

Hey everyone!

I have a project which has the obvious "start" and "end" date columns and Smartsheet automatically calculates the actvity duration. Is there a formula or something which will calculate and display "elapsed" time from start based on the current date?

Thanks!

Steve Stutz

 

Jeff K.

Do you mean a formula that will calculate the number of days between the start date and today's date?

 

=TODAY()-[StartDateColumn]1

 

http://help.smartsheet.com/customer/portal/articles/775363-using-formulas#date

 

NOTE: it will be negative if TODAY() is before the start date.

Jess Price

Try this.

=Round(IF(TODAY()<[Start],"0",TODAY()-[Start]),0)

Dr. Steve Stutz

Yes. that's exactly it. The difference between "start date" and "today's date." 

J McMahon

Hello there,

I'm looking for the same data, and when I use your formula I end up with #UNPARSEABLE

I've changed "Start" to " Start Date" as that's the name of the column I'm trying to calculate the date from

I'm new the Smartsheets and appreciate any guidance.  

Best,

J

J. Craig Williams

Jess' formula is incorrect.

cell reference is [column]row-number

like this

[Start Date]23 

or

[Start Date]@row

for the same row the formula is on.

Something like this:

=TODAY()-[Start Date]@row

might be what you are looking for.

Craig