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

Mass Add Dropdown Value without Overwriting the Existing Content
Hi folks, I have a column set up as multi-value dropdown list, I would like to mass add a value to a range of cells in this column, is there an efficient way to do so? For example (see below screenshot), I want to add "E" to all the cells below, my current method would be manually adding it to each cell, which is somewhat…
SUMIFS Question
Hi everyone, I’m currently putting together a formula sheet for one of our trackers and could use your guidance. As per the attached screenshot, my goal is to pull a monthly view of the total “Transfer Quantity” per “Category” from the source sheet. I’ve tried several SUMIFS formulas, but I keep running into an…
Move project rows if all descendant rows are complete
Hello! I'm fairly new to Smartsheet and I'm working to set up an automation to move project rows to an archived sheet once everything for the project is complete. I'm hoping someone can help me out with a specific formula. I have tasks and subtasks under my projects. I want to verify that all project items are complete…