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

CountIF + Wild Card - Help Needed
Hi all. I'm trying to count all the rows where a specific columns includes certain words. So for example, I want to count all the rows where the column includes the word "assembly." I have used the below formula and entered a test row that includes assembly in the required column. However the formula is returning 0. Can…
Monthly Capacity Formula
I am trying to have the Helper (Time) be aligned to the Resource Name including/across the months within Est Start Date and Actual End Date. This would include any Helper (Time) value and Est Start Date and Actual End Date values aligned to any project for that Resource Name. Current state I can calculate the total Helper…
Cross-sheet conditional logic while waiting for dynamic filtering for linked dropdowns
Context Sheet 1 (Budget) contains the budget for a division with multiple teams. Each line item is associated with a specific project/team ([Project Name]). Each project has a Cost Center [CC] number and internal order number [IO] to tie spend back to the specific project at the end of each month (pulled from master list,…