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

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

Find more posts tagged with

Calendar View

Formulas

Cell linking

Comments

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. Craig Williams

Jess' formula is incorrect.

cell reference is [column]row-number

like this

[Start Date]23

[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