nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

=NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) returns 1 when date is the

Lawrence Ough

Using formula as follows should return with a 0 if the dates are the same. Why is it returning a 1 instead? A similar formula if used in Excel will return a 0, so I would assume Smartsheets would do the same. Am I missing something in the formula?

Thanks,

Lawrence

Find more posts tagged with

Formulas

Project Management

Media & Entertainment

Comments

Chris McKay

If it's in a project template, Smartsheet may be allocating a full workday to the date range. Smartsheet also doesn't deal with times very well and UTC vs Local time can cause issues with the displayed date being different to the underlying system date.

So [Expected Finish Launch Date]48 may be starting at 9am and [Planned Finish Launch Date]48 may finish at 5pm. Or the dates may even be treated by Smartsheet as different (despite the date being displayed the same). Someone else out there may know more about this.

I know it's weird behaviour, but if it's consistent then you can possibly counteract it by changing the formula to =NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) -1

Or I could just be speaking waffling off on a tangent and be completely wrong

Lawrence Ough

Thanks, Chris! I agree with your theory, and your formula suggestion is just what I needed. Thanks so much!!

Regards,

Lawrence

Chris McKay

My pleasure Lawrence

Sign in to join the conversation!

Quick Links

Trending discussions

How to create a timestamp that can't be changed once it's been populated
I would like to create a timestamp that records the time and date the first time a cell is populated, and never changes after that. This can be done in Excel with VBA code. Can this be done in Smartsheet? Also, this cell should remain blank if the reference cell is blank.
Form Validation
Is anyone having issues with the Form Validation for Number only? When we have Number only selected, users are unable to key in a number - we have had to change the form to No Validation
Need formula that converts HH:MM:SS to total seconds
HI, Seeking formula assist. I have to collect monthly stats that inlcude HH:MM:SS, however I am unable to average a full quarter in smartsheet becasue this format, HH:MM:SS is deemed text. 1- What is the formula needed in the helper column to convert HH:MM:SS shown in column labeled JAN into seconds in the helper column 2-…