Formulas

NETWORKDAY/S

Can why does this formula above give out different numbers when the start and end date (automated by column) are the same.

Eg...

=NETWORKDAYS(Date created, Date modified) = no of days

Date created column = 01 august 2019 (tues), Date modified column = 01 August 2019 (tues) = 1

On the next line it will say

Date created column = 01 august 2019 (tues), Date modified column = 02 August 2019 (tues) = 1

Why are this formula still reading 1 on the second line???

Does Am and PM get taken into consideration in this formula?????

Find more posts tagged with

Formulas

Comments

Mike Wilday

There are several potential factors that are accounted for in this equation. The first is that Smartsheets displays Local Time, but in the backend they calculate based on the server's local time or some kind of GMT time. There will be occasions where I am displaying the local time but its calculating on 3 hours earlier or later. Try downloading your sheet in excell. It usually converts the dates there to the server times. Let me know what you find?

SharonR

It does work, but downloading the data would defeat the purpose of having this data in Smartsheets. This data feeds multiple projects across our office. If it can not calculate the time correctly our statistics will be out across all our sheets.

Is common for all Network/Networking/Networkingdays formulas?

Mike Wilday

I agree with you wholeheartedly. Its doesn't make any sense and can be a bear when factoring dates. I happen to know that more focused time stamps are coming soon. Hopefully in the last quarter.

Sign in to join the conversation!

Quick Links

Trending discussions

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])