FS date calculation issue

I have the following calculated task dates in a gantt chart:

Task no. Duration Early start Early Finish Dependency

22 60d 1-Feb-2021 23-Apr-2021

23 60d 29-Jan-2024 19-Apr-2024 22FS+720d

(See attached screenshot) Task #23 is supposed to start 720d after #22 has finished. But if you manually check the number of days between Task #22 finish and Task #23 start, it is over 1000d - nothing like the 720d. Any idea of the logic? I use calendar days for my durations and lags; only Saturdays and Sundays are non-working days.

Find more posts tagged with

Calendar View

Gantt View

Comments

Paul Newcome

When inputting it as x number of days, Smartsheet calculates that as working days. Try using weeks instead and see if that works for you.

rsawoseyin62571

Thanks for your suggestion. Entering durations in weeks did not help. What would be useful is for one to be able to choose from entering durations in either calendar days or working days. For projects that span several years, it is far more practical to quote durations in calendar days. Furthermore, in the construction industry, there are activities that take place 24/7 and the concept of working days is virtually meaningless. Management relate more readily to calendar days.

Paul Newcome

If Calendar days works more appropriately for your particular situation, would you be able to include Saturday and Sunday as working days, or would that throw other things off?

Sign in to join the conversation!

Quick Links

Trending discussions

Attachments with Widgets
I have a dashboard that has a report widget and I was wondering, can that widget also show the documents attached to a row so you can click on them or is that only in the sheet?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option?
Is there a way to prevent a shared user from seeing the data in the "View Detail" option? I'm trying to make sure that when a user is given access to view a report, they can only view the columns present in that report. The view might only show certain columns but the user can then click on the record as shown below and…
Gantt Chart Timescale not aligning with projects fiscal year and start/end dates
I have a project sheet with a Gantt chart where the timescale headings are not aligning with my project’s fiscal year and start/end dates. Configuration: - Primary heading: Quarters (displaying as Q4 2026) - Secondary heading: Months (MMM format) - Fiscal year start: February 2 - Week start: Sunday - Project start date:…