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

"Something Went Wrong" when Closing Formula Pane in Table View (Sheet)
I am working in a sheet (Table View) editing a formula. Once I apply the formula (to the column), and then close out of the formula sidebar, I always get the following error, over and over even when I click OK. I have to reload the page. The edits to the formula are still there, thankfully. Anyone else get this error, and…
Losing the will to live with Smartsheet. Please help
This is my second time giving Smartsheet a chance and it's going to take a lot for someone to convince me this platform is any good whatsoever. The Problem: I created a Portfolio from their template, and all fine as I was working through etc., except for the project plan template. For some reason, when I get to a certain…
Automation Troubles
Hello! I need to make a report/ sheet that when "Documentation Ordered" is checked, the row is copied to the report. When I try to do this, all of the other child rows are also copied to the report. I also need the blue title row (currently says "Documentation") to be included. When I try to do this, It's parent row and…