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

Due Date for only working days
I have a due date column that I want to show only working days and exclude Saturday, Sunday and Holidays. How do I set this up?
Contact List fields
I'm working on a project where I want to reference the contact list field in an automation email body, but it only pulls the Name field of the contact list item. Is there a way to get just the email address or does anyone have a good workaround for this?
Prevent ID reassignment if RAID Type changes except for existing row
I am currently using the formula below to auto-create IDs based on the Module, Subworkstream and RAID Type of each item in my sheet. The problem that I am having is that if the RAID type changes, it resets every ID in the list. How do I prevent that from happening? Hoping for some guidance. Thank you!!! =[HELPER COLUMN:…