Calculating Days Between Estimated and Actual Start Dates (including projects which haven't started)
Options
Hi!
I've got a project tracking sheet that has the following columns:
Estimated Start Date
Actual Start Date
I need to calculate how long a project has been waiting to start. Some projects don't have an actual start date, though. So the formula needs to know that blank dates in the actual start column should be counted as "TODAY."
Any ideas on how to get this calculation done?
THANKS!
-Hannah
Answers
-
To use the [Actual Start] if it is a date and TODAY() if it is not, you would use a basic IF statement.
=IF(ISDATE([Actual Start]@row), [Actual Start]@row, TODAY())
Then you would just subtract the [Estimated Start] from that.
=IF(ISDATE([Actual Start]@row), [Actual Start]@row, TODAY()) - [Estimated Start]@row
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!