Formulas

SharonR

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?????

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.