Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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
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.
Try this.=Round(IF(TODAY()<[Start],"0",TODAY()-[Start]),0)
Yes. that's exactly it. The difference between "start date" and "today's date."
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
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
